Unfortunately, the attachments / pictures haven't come through. Mailing lists sometimes do not support these. Can you paste as text or share links to it instead?
On Sun, Jul 23, 2017 at 9:14 PM, Divya Gehlot <[email protected]> wrote: > 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 <[email protected]> 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/#col >> umns[n]-syntax >> On Sun, Jul 23, 2017 at 8:44 PM Divya Gehlot <[email protected]> >> 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 >> > >> > >
