Re: SMB join bug

2014-05-11 Thread Sukhendu Chakraborty
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 sukhendu.chakrabo...@gmail.com wrote: I am seeing very different number of rows in this query output depending on whether I enable

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

[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-tabpanelfocusedCommentId=13968639#comment-13968639 ] sukhendu chakraborty commented on HIVE-6904: Only suggested workaround

[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

[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

[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-tabpanelfocusedCommentId=13968646#comment-13968646 ] sukhendu chakraborty commented on HIVE-6904: Detailed discussion can be found

[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] [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

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 table? From http://osdir.com/ml/hive-user-hadoop-apache/2009-03/msg00094.html it looks like the

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-tabpanelfocusedCommentId=13278101#comment-13278101 ] sukhendu chakraborty commented on HIVE-1449: I have slightly different symptoms