Writing columns having NULL as some string using OpenCSVSerde

2017-03-27 Thread Punit Shetty
Hi, I'm using 'org.apache.hadoop.hive.serde2.OpenCSVSerde' to write hive table data. CREATE TABLE testtable ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde' WITH SERDEPROPERTIES ( "separatorChar" = ",", "quoteChar" = "'" ) STORED AS TEXTFILE LOCATION '' AS select * from

Re: Missing column headers from S3 file

2017-03-09 Thread Punit Shetty
Yes, running the CTAS command on hive CLI does print the headers once the query execution is completed. I think this feature is yet to be implemented: https://issues. apache.org/jira/browse/HIVE-12860 On Thu, Mar 9, 2017 at 9:50 AM, Punit Shetty <punitshett...@gmail.com> wrote: > Yes

Missing column headers from S3 file

2017-03-08 Thread Punit Shetty
Hi, I'm trying to get the column headers into a S3 file. When I run this on the hive command line: set hive.cli.print.header=true; select * from abc; Things work fine, I'm able to see the column headers with the table data on the console. But my query is, when I try something like this: set