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
wrote:
> Yes, running the CTAS command on hive CL
apologies,
my command was
hive -e "set hive.cli.print.header=true; *select * from abc*" >> output.txt
Thank you,
*Pushkar Gujar*
On Wed, Mar 8, 2017 at 8:49 PM, Pushkar.Gujar
wrote:
> if you were running CTAS command from hive CLI, you might have noticed
> that headers get printed in CLI on
if you were running CTAS command from hive CLI, you might have noticed that
headers get printed in CLI once the query execution is completed. I think
the property hive.cli.print.header is there to only print headers only in
cli.
Not sure about S3, but I tried below which worked perfectly
hive -e
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 hiv
