yes it shows the proper values when I query the csv file. CTAS query csv to parquet : Create table `dfs`.`tmp`.`publicholiday.parquet` AS SELECT CASE WHEN `Day` = '' THEN CAST(NULL AS VARCHAR(100)) ELSE CAST(`Day` AS VARCHAR(100)) END AS `Day`, CASE WHEN `Date` = '' THEN CAST(NULL AS VARCHAR(100)) ELSE CAST(`Date` AS VARCHAR(100)) END AS `Date`, CASE WHEN `Area` = '' THEN CAST(NULL AS VARCHAR(100)) ELSE CAST(`Area` AS VARCHAR(100)) END AS `Area` FROM TABLE (dfs.`PublicHoliday.csv`(type => 'text',fieldDelimiter => ',', extractHeader => true))
CSV File Parquet File Appreciate the help ! Thanks, Divya On 24 July 2017 at 11:52, Abhishek Girish <agir...@apache.org> wrote: > 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 > > >