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

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.

[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

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.

[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

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

[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

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-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:

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 raaja...@gmail.commailto:raaja...@gmail.com Reply-To: u...@hive.apache.orgmailto:u...@hive.apache.org u...@hive.apache.orgmailto:u...@hive.apache.org Date: Monday,

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

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

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

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 table name compute statistics; Thanks John On 8/24/15, 6:24 PM, Raajay raaja...@gmail.com wrote: Hi John, I am on Hive-2.0.0. I forked of the Hive master

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 jpullokka...@hortonworks.commailto:jpullokka...@hortonworks.com Reply-To: u...@hive.apache.orgmailto:u...@hive.apache.org u...@hive.apache.orgmailto:u...@hive.apache.org Date: Monday, August 24, 2015 at 5:23 PM To:

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

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

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