Re: Dynamic partition raising exception while creation

2013-06-16 Thread Nitin Pawar
in any search engine you like, search for "*could only be replicated to 0 nodes, instead of 1" * On Mon, Jun 17, 2013 at 11:44 AM, Hamza Asad wrote: > Im trying to create partition table (dynamically) from old non partitioned > table. the query is as follow > > *INSERT OVERWRITE TABLE new_even

Dynamic partition raising exception while creation

2013-06-16 Thread Hamza Asad
Im trying to create partition table (dynamically) from old non partitioned table. the query is as follow *INSERT OVERWRITE TABLE new_events_details Partition (event_date) SELECT id, event_id, user_id, intval_1, intval_2, intval_3, intval_4, intval_5, intval_6, intval_7, intval_8, intval_9, intval_

Re: Wrong values returned for nullable columns in hbase tables when accessed via hive

2013-06-16 Thread Navis류승우
Looks like it's https://issues.apache.org/jira/browse/HIVE-3179, which is fixed in hive 0.11.0 2013/6/14 Rupinder Singh : > Hi all, > > > > I am facing an issue when selecting a nullable column twice in a hive select > statement against an hbase table. For rows where that column is null, 2 > diffe

When to use bucketed tables with/instead of partitioned tables

2013-06-16 Thread Stephen Boesch
I am accustomed to using partitioned tables to obtain separate directories for data files in each partition. When looking at the documentation for bucketed tables it seems they are typically used in conjunction with distribute by/sort by and an appropriate partitioning key - and thus provide abili

Re: dynamic Partition not splitting properly

2013-06-16 Thread Hamza Asad
Im trying to create partition table (dynamically) from old non partitioned table. the query is as follow *INSERT OVERWRITE TABLE new_events_details Partition (event_date) SELECT id, event_id, user_id, intval_1, intval_2, intval_3, intval_4, intval_5, intval_6, intval_7, intval_8, intval_9, intval_