[jira] [Created] (HIVE-11639) hive-exec jar contains within itself other jars

2015-08-24 Thread Ratandeep Ratti (JIRA)
Ratandeep Ratti created HIVE-11639: -- Summary: hive-exec jar contains within itself other jars Key: HIVE-11639 URL: https://issues.apache.org/jira/browse/HIVE-11639 Project: Hive Issue Type:

[jira] [Created] (HIVE-11638) ExprNodeDesc hashMap accidentally degrades into O(N) instead of O(1)

2015-08-24 Thread Gopal V (JIRA)
Gopal V created HIVE-11638: -- Summary: ExprNodeDesc hashMap accidentally degrades into O(N) instead of O(1) Key: HIVE-11638 URL: https://issues.apache.org/jira/browse/HIVE-11638 Project: Hive Issue

[jira] [Created] (HIVE-11637) Support hive.cli.print.current.db in new CLI[beeline-cli branch]

2015-08-24 Thread Ferdinand Xu (JIRA)
Ferdinand Xu created HIVE-11637: --- Summary: Support hive.cli.print.current.db in new CLI[beeline-cli branch] Key: HIVE-11637 URL: https://issues.apache.org/jira/browse/HIVE-11637 Project: Hive

Re: CBO - get cost of the plan

2015-08-24 Thread John Pullokkaran
>From the text below it seems like you are not collecting table level stats. You can collect table level stats by following analyze table compute statistics; Thanks John On 8/24/15, 6:24 PM, "Raajay" wrote: >Hi John, > >I am on Hive-2.0.0. I forked of the Hive master branch 2 weeks back >(

Re: CBO - get cost of the plan

2015-08-24 Thread Raajay
Hi John, I am on Hive-2.0.0. I forked of the Hive master branch 2 weeks back (commit id: 763cb02b5eafb0ecd3fd0eb512636a1b092df671). I actually have "analyze" before I execute the query. I left it out for brevity. Please find the entire query (sent to hive in a file) below. Without the analyze co

Re: Review Request 37620: Hive Parser to Support multi col in clause (x, y..) in ((..), ..., ())

2015-08-24 Thread John Pullokkaran
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/37620/#review96264 --- ql/src/java/org/apache/hadoop/hive/ql/parse/IdentifiersParser.g (li

[jira] [Created] (HIVE-11636) NPE in stats conversion with HBase metastore

2015-08-24 Thread Sergey Shelukhin (JIRA)
Sergey Shelukhin created HIVE-11636: --- Summary: NPE in stats conversion with HBase metastore Key: HIVE-11636 URL: https://issues.apache.org/jira/browse/HIVE-11636 Project: Hive Issue Type: S

[jira] [Created] (HIVE-11635) import tool fails on unsecure cluster

2015-08-24 Thread Sergey Shelukhin (JIRA)
Sergey Shelukhin created HIVE-11635: --- Summary: import tool fails on unsecure cluster Key: HIVE-11635 URL: https://issues.apache.org/jira/browse/HIVE-11635 Project: Hive Issue Type: Sub-task

Re: CBO - get cost of the plan

2015-08-24 Thread John Pullokkaran
In addition to col stats you also need table stats. From: John Pullokkaran mailto:jpullokka...@hortonworks.com>> Reply-To: "u...@hive.apache.org" mailto:u...@hive.apache.org>> Date: Monday, August 24, 2015 at 5:23 PM To: "u...@hive.apache.org

Re: CBO - get cost of the plan

2015-08-24 Thread John Pullokkaran
Raajay, You don't have col stats hence it assumes 1 for row count. What version of Hive are you on? Thanks John From: Raajay mailto:raaja...@gmail.com>> Reply-To: "u...@hive.apache.org" mailto:u...@hive.apache.org>> Date: Monday, August 24, 2015 at 5:19 PM To: "

CBO - get cost of the plan

2015-08-24 Thread Raajay
Hello, I am interested to get the cost of the query plans as calculated by the CBO. How can I get that information ? For example, consider a query with a three way join of the following form: Query = insert overwrite table output_tab select a_day, a_product, b_alternate, (a_sales + b_sales +

[jira] [Created] (HIVE-11634) Support partition pruning for IN(STRUCT(partcol, nonpartcol..)...)

2015-08-24 Thread Hari Sankar Sivarama Subramaniyan (JIRA)
Hari Sankar Sivarama Subramaniyan created HIVE-11634: Summary: Support partition pruning for IN(STRUCT(partcol, nonpartcol..)...) Key: HIVE-11634 URL: https://issues.apache.org/jira/browse/HIVE

[jira] [Created] (HIVE-11633) import tool should print help by default

2015-08-24 Thread Sergey Shelukhin (JIRA)
Sergey Shelukhin created HIVE-11633: --- Summary: import tool should print help by default Key: HIVE-11633 URL: https://issues.apache.org/jira/browse/HIVE-11633 Project: Hive Issue Type: Sub-t

[jira] [Created] (HIVE-11632) import tool is too brittle (fails on existing role)

2015-08-24 Thread Sergey Shelukhin (JIRA)
Sergey Shelukhin created HIVE-11632: --- Summary: import tool is too brittle (fails on existing role) Key: HIVE-11632 URL: https://issues.apache.org/jira/browse/HIVE-11632 Project: Hive Issue

[jira] [Created] (HIVE-11631) TFetchResultsResp hasMoreRow and startRowOffset not returning actual values

2015-08-24 Thread Jenny Kim (JIRA)
Jenny Kim created HIVE-11631: Summary: TFetchResultsResp hasMoreRow and startRowOffset not returning actual values Key: HIVE-11631 URL: https://issues.apache.org/jira/browse/HIVE-11631 Project: Hive

[jira] [Created] (HIVE-11630) Use string intering with HiveConf to be more space efficient

2015-08-24 Thread Vaibhav Gumashta (JIRA)
Vaibhav Gumashta created HIVE-11630: --- Summary: Use string intering with HiveConf to be more space efficient Key: HIVE-11630 URL: https://issues.apache.org/jira/browse/HIVE-11630 Project: Hive

[jira] [Created] (HIVE-11629) CBO: Calcite Operator To Hive Operator (Calcite Return Path) : fix the filter expressions for full outer join and right outer join

2015-08-24 Thread Pengcheng Xiong (JIRA)
Pengcheng Xiong created HIVE-11629: -- Summary: CBO: Calcite Operator To Hive Operator (Calcite Return Path) : fix the filter expressions for full outer join and right outer join Key: HIVE-11629 URL: https://issues

Re: Review Request 37333: HIVE-11515 Still some possible race condition in DynamicPartitionPruner

2015-08-24 Thread Siddharth Seth
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/37333/#review96189 --- Ship it! After the fix to the log line being an exception. ql/src

[jira] [Created] (HIVE-11628) DB type detection code is failing on Oracle 12

2015-08-24 Thread Deepesh Khandelwal (JIRA)
Deepesh Khandelwal created HIVE-11628: - Summary: DB type detection code is failing on Oracle 12 Key: HIVE-11628 URL: https://issues.apache.org/jira/browse/HIVE-11628 Project: Hive Issue T

Re: Review Request 37660: HiveServer2 should store connection params in ZK when using dynamic service discovery for simpler client connection string.

2015-08-24 Thread Vaibhav Gumashta
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/37660/ --- (Updated Aug. 24, 2015, 7:22 p.m.) Review request for hive and Thejas Nair. B

[jira] [Created] (HIVE-11627) Make PPD optimizer run faster

2015-08-24 Thread Jesus Camacho Rodriguez (JIRA)
Jesus Camacho Rodriguez created HIVE-11627: -- Summary: Make PPD optimizer run faster Key: HIVE-11627 URL: https://issues.apache.org/jira/browse/HIVE-11627 Project: Hive Issue Type: Im

[jira] [Created] (HIVE-11626) ResultSetMetaData.getColumnName() returns compound "table_name.column_name"

2015-08-24 Thread Roger Bjarevall (JIRA)
Roger Bjarevall created HIVE-11626: -- Summary: ResultSetMetaData.getColumnName() returns compound "table_name.column_name" Key: HIVE-11626 URL: https://issues.apache.org/jira/browse/HIVE-11626 Project

[jira] [Created] (HIVE-11625) Map instances with null keys are not written to Parquet tables

2015-08-24 Thread Cheng Lian (JIRA)
Cheng Lian created HIVE-11625: - Summary: Map instances with null keys are not written to Parquet tables Key: HIVE-11625 URL: https://issues.apache.org/jira/browse/HIVE-11625 Project: Hive Issue