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
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
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