Re: SMB join bug

2014-05-11 Thread Sukhendu Chakraborty
it this issue - > https://issues.apache.org/jira/browse/HIVE-5973 > It is fixed in apache hive 0.13 release. > > > On Thu, May 1, 2014 at 7:10 PM, Sukhendu Chakraborty > wrote: > > I am seeing very different number of rows in this query output depending > on > > w

SMB join bug

2014-05-01 Thread Sukhendu Chakraborty
I am seeing very different number of rows in this query output depending on whether I enable SMB join: select count(*) from dss.hist_hshld_profl_mc a join dss.hshld_summary_mc b on a.hh_key = b.hh_key where ('2012-02-27' between a.hshld_profl_eff_dt and a.hshld_pro

[jira] [Resolved] (HIVE-6904) out of sequence error in HiveMetastore server when connecting from HS2

2014-04-14 Thread sukhendu chakraborty (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] sukhendu chakraborty resolved HIVE-6904. Resolution: Duplicate Duplicate of HIVE-6893 > out of sequence error

[jira] [Updated] (HIVE-6893) out of sequence error in HiveMetastore server

2014-04-14 Thread sukhendu chakraborty (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] sukhendu chakraborty updated HIVE-6893: --- Summary: out of sequence error in HiveMetastore server (was: Out of sequence

[jira] [Commented] (HIVE-6904) out of sequence error in HiveMetastore server when connecting from HS2

2014-04-14 Thread sukhendu chakraborty (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13968646#comment-13968646 ] sukhendu chakraborty commented on HIVE-6904: Detailed discussion can be f

[jira] [Updated] (HIVE-6904) out of sequence error in HiveMetastore server when connecting to the metastore server

2014-04-14 Thread sukhendu chakraborty (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] sukhendu chakraborty updated HIVE-6904: --- Summary: out of sequence error in HiveMetastore server when connecting to the

[jira] [Updated] (HIVE-6904) out of sequence error in HiveMetastore server when connecting from HS2

2014-04-14 Thread sukhendu chakraborty (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] sukhendu chakraborty updated HIVE-6904: --- Summary: out of sequence error in HiveMetastore server when connecting from HS2 (was

[jira] [Created] (HIVE-6904) out of sequence error in HS2 when connecting to the metastore server

2014-04-14 Thread sukhendu chakraborty (JIRA)
sukhendu chakraborty created HIVE-6904: -- Summary: out of sequence error in HS2 when connecting to the metastore server Key: HIVE-6904 URL: https://issues.apache.org/jira/browse/HIVE-6904 Project

[jira] [Commented] (HIVE-6904) out of sequence error in HS2 when connecting to the metastore server

2014-04-14 Thread sukhendu chakraborty (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13968639#comment-13968639 ] sukhendu chakraborty commented on HIVE-6904: Only suggested workaround i

appending data to clustered tables.

2014-02-19 Thread Sukhendu Chakraborty
Hi, Is there a way to add data into a bucketed/clustered table in hive-0.11. I have a clustered table with 32 buckets (no partitions) with some data, can I append more data by running a "insert into "? From http://osdir.com/ml/hive-user-hadoop-apache/2009-03/msg00094.html it looks like the fea

mapjoin on subquery result

2013-12-04 Thread Sukhendu Chakraborty
Hi, Is there anyway mapjoin works on the subquery(not the underlying table). I have the following query: select external_id,count(category_id) from catalog_products_in_categories_orc pc inner join (select * from catalog_products_orc where s_id=118) p on pc.product_id=p.id group by external_id;

map join in subqueries

2013-12-03 Thread Sukhendu Chakraborty
Hi, Is there anyway mapjoin works on the subquery(not the underlying table). I have the following query: select external_id,count(category_id) from catalog_products_in_categories_orc pc inner join (select * from catalog_products_orc where s_id=118) p on pc.product_id=p.id group by external_id;

HIVE optimizer enhancements in 0.9.0+ releases

2012-11-15 Thread Sukhendu Chakraborty
Hi, I am a HIVE user who is working on anlytical applications on large data sets. For us, the HIVE performance is critical for the success of our product. I was wondering if there are any recent improvements that were made in the optimizer layer. One of the relevant references I found on the web

HIVE optimizer enhancements in 0.9.0+ releases

2012-11-15 Thread Sukhendu Chakraborty
Hi, I am a HIVE user who is working on anlytical applications on large data sets. For us, the HIVE performance is critical for the success of our product. I was wondering if there are any recent improvements that were made in the optimizer layer. One of the relevant references I found on the web

HIVE optimizer enhancements in 0.9.0+ releases

2012-11-15 Thread Sukhendu Chakraborty
Hi, I am a HIVE user who is working on anlytical applications on large data sets. For us, the HIVE performance is critical for the success of our product. I was wondering if there are any recent improvements that were made in the optimizer layer. One of the relevant references I found on the web

[jira] [Commented] (HIVE-1449) Table aliases in order by clause lead to semantic analysis failure

2012-05-17 Thread sukhendu chakraborty (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13278101#comment-13278101 ] sukhendu chakraborty commented on HIVE-1449: I have slightly diffe

[jira] [Commented] (HIVE-2980) Show a warning or an error when the data directory is empty or not existing

2012-04-25 Thread sukhendu chakraborty (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2980?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13261875#comment-13261875 ] sukhendu chakraborty commented on HIVE-2980: I tend to disagree with Ashu