hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "caofangkun (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-4346) when writing data into filesystem from queries ,the output files could contain a line of column names
Date Mon, 15 Apr 2013 03:44:14 GMT

     [ https://issues.apache.org/jira/browse/HIVE-4346?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

caofangkun updated HIVE-4346:
-----------------------------

    Description: 
For example :
hive>desc src;
key string
value string

hive>select * from src;
1 10
2 20

hive>set hive.output.contain.columnnames=true;
hive>insert overwrite local directory './test1' select * from src ;
hive>!ls -l './test1';
./test1/_metadata
./test1/000000_0

hive>!cat './test1/_metadata'
key^Avalue

hive>!cat './test1/000000_0';
1^A10
2^A20


  was:
For example :
hive>desc src;
key string
value string
hive>select * from src;
1 10
2 20
hive>set hive.output.contain.columnnames=true;
hive>insert overwrite local directory './test1' select * from src ;
hive>!cat './test1/000000_0';
key^Avalue
1^A10
2^A20

    
> when writing data into filesystem from queries ,the output files could contain a line
of column names 
> ------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-4346
>                 URL: https://issues.apache.org/jira/browse/HIVE-4346
>             Project: Hive
>          Issue Type: New Feature
>          Components: Query Processor
>            Reporter: caofangkun
>            Priority: Minor
>
> For example :
> hive>desc src;
> key string
> value string
> hive>select * from src;
> 1 10
> 2 20
> hive>set hive.output.contain.columnnames=true;
> hive>insert overwrite local directory './test1' select * from src ;
> hive>!ls -l './test1';
> ./test1/_metadata
> ./test1/000000_0
> hive>!cat './test1/_metadata'
> key^Avalue
> hive>!cat './test1/000000_0';
> 1^A10
> 2^A20

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message