Shud partition order be same in create and insert?

2010-08-06 Thread Thiruvel Thirumoolan
Hello, When the order of partitioning columns is different in create table and insert, I am not able to query for any data. However if the order is the same its possible to see data. Should partitioning order be maintained through all inserts? As you see below, kv2.txt is still on HDFS and 2

how to debug code in org.apache.hadoop.hive.ql.exec package

2010-08-06 Thread lei liu
how can I debug code in org.apache.hadoop.hive.ql.exec package?

RE: Shud partition order be same in create and insert?

2010-08-06 Thread Namit Jain
The order should be the same. Can you file a jira for this issue ? We should throw an error. Thanks, -namit From: Thiruvel Thirumoolan [thiru...@yahoo-inc.com] Sent: Friday, August 06, 2010 12:29 AM To: hive-user@hadoop.apache.org Subject: Shud

RE: How to merge small files

2010-08-06 Thread Namit Jain
HIVEMERGEMAPFILES(hive.merge.mapfiles, true), HIVEMERGEMAPREDFILES(hive.merge.mapredfiles, false), Set the above parameters to true before your query. From: lei liu [liulei...@gmail.com] Sent: Thursday, August 05, 2010 8:47 PM To:

Syntax and Semantics for Continuous queries in Hive

2010-08-06 Thread Shyam Sarkar
Hello, I am curious whether large streaming data can be queried by syantax and semantics of continuous queries inside Hive as defined in Streams Databases (e.g. StreamBase, Coral8 etc.). Continuous queries are essential for real-time enterprise, log data and many other applications. Thanks,

Re: How HIVE manages a join

2010-08-06 Thread Jeff Hammerbacher
Yongqiang mentioned he was going to update the wiki with this information in the thread at http://hadoop.markmail.org/thread/hxd4uwwukuo46lgw. Yongqiang, have you gotten a chance to complete the sort merge bucket map join and the other skew join you mention in the above thread? Thanks, Jeff On