Can we merge schema from two files while creating PDS

Dremio University
1

Hi,

I have two files placed under single folder with similar schema, except the second file has one extra column in it. Can we create One single PDS with two file under same folder.

file 1 structure -
±-------+±-------+±-------+
|Id | Name | Age |
±-------+±-------+±-------+

file 2 structure -
±-------+±-------+±-------+±-------+
|Id | Name | Age | City |
±-------+±-------+±-------+±-------+

Thanks

2

@Gaurav Yes, Dremio will do a schema learning for the extra column and place a value of null for the row it does not exist