Can you share a sample row from the CSV and the CTAS query? Also test if a select columns[n] query on the CSV file works as expected [1] ?
It could be an issue with delimiters. [1] https://drill.apache.org/docs/querying-plain-text-files/#columns[n]-syntax On Sun, Jul 23, 2017 at 8:44 PM Divya Gehlot <divya.htco...@gmail.com> wrote: > Hi , > I am facing as weird issue when I CTAS and save the csv file as parquet it > displays the last column values as null . > This is not the case with one file . > If I take any csv file with even with any data type and do a > select column1,column2,column3 from table.parquet > it shows the column3 values as null. > > Appreciate the help. > > Thanks, > Divya >