| clear query|facets|time |
Search criteria: .
Results from 1 to 8 from
8 (0.083s).
|
|
|
Loading phrases to help you
refine your search...
|
|
Re: '\N' is displayed in case of null column values in exporting hive query results to CSV file - Hive - [mail # user]
|
|
...Well a quick dirty way would be to use CASE WHEN with your SELECT statement. Eg. create table tmp_test ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' as select ...
|
|
|
Author: Ashwanth Kumar,
2012-05-02, 05:26
|
|
|
Re: '\N' is displayed in case of null column values in exporting hive query results to CSV file - Hive - [mail # user]
|
|
...Is the NULL value column located in last (in schema)? On Wed, May 2, 2012 at 10:44 AM, Garg, Rinku wrot e: t, ‘\N’ .plugin.system.issuetabpanels:changehistory-tabpanel#issue-tabs...
|
|
|
Author: Ashwanth Kumar,
2012-05-02, 05:20
|
|
|
Re: add column to hive table - Hive - [mail # user]
|
|
...You can only add columns at the end. If you are using the native SerDe try ALTER TABLE tbl_name REPLACE COLUMNS (column1 int, mynewcolumn string, column2 int); More information o...
|
|
|
Author: Ashwanth Kumar,
2012-04-30, 22:55
|
|
|
Re: Any column search in HIVE - Hive - [mail # user]
|
|
...Try this option - In order to achieve that, create the table with ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' Now create any data you insert into that TABLE is stored internally as CSV. &n...
|
|
|
Author: Ashwanth Kumar,
2012-04-30, 08:43
|
|
|
Re: Re: cannot start the thrift server - Hive - [mail # user]
|
|
...Hey ylyy, You are using the default Derby based metastore in your hive configuration. So when you have your HIVE Thrift Server running it locks the metastore_db and hence HIVE CLI cann...
|
|
|
Author: Ashwanth Kumar,
2012-04-11, 03:57
|
|
|
Re: Hive table creation error - Hive - [mail # user]
|
|
...Seems most likely that the CSV file block is lost or unreadable. Quick questions? - What is the dfs.replication in your Hadoop cluster? - Can you share the Query used for creatin...
|
|
|
Author: Ashwanth Kumar,
2012-04-06, 03:12
|
|
|
Re: Question - Nested JSON using Hive - Hive - [mail # user]
|
|
...not possible. ARRAY is like a LIST which supports only one type. For your case try something with STRUCT may be that suits your use-case better. Read this link - https://cwiki.ap...
|
|
|
Author: Ashwanth Kumar,
2012-04-02, 08:59
|
|
|
Re: Question - Nested JSON using Hive - Hive - [mail # user]
|
|
...You get that error because "location" is a keyword in Hive. Try to encapsulate it in ` char and try. On Mon, Apr 2, 2012 at 7:07 AM, Anurag Gulati wrote ’t but a): 983","hometown...
|
|
|
Author: Ashwanth Kumar,
2012-04-02, 03:53
|
|
|
|
