[jira] [Created] (HIVE-13713) We miss vectorization in a case of count(*) when aggregation mode is COMPLETE

2016-05-07 Thread Matt McCline (JIRA) 
Matt McCline created HIVE-13713:
---

 Summary: We miss vectorization in a case of count(*) when 
aggregation mode is COMPLETE
 Key: HIVE-13713
 URL: https://issues.apache.org/jira/browse/HIVE-13713
 Project: Hive
  Issue Type: Bug
  Components: Hive
Reporter: Matt McCline
Assignee: Matt McCline
Priority: Critical






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Created] (HIVE-13714) How to config hive metastore mysql connection pool size?

2016-05-07 Thread Tao Li (JIRA) 
Tao Li created HIVE-13714:
-

 Summary: How to config hive metastore mysql connection pool size?
 Key: HIVE-13714
 URL: https://issues.apache.org/jira/browse/HIVE-13714
 Project: Hive
  Issue Type: Bug
  Components: Metastore
Affects Versions: 0.13.1
Reporter: Tao Li


How to config hive metastore mysql connection pool size?



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Re: Review Request 46671: HIVE-13598 : Describe extended table should show the primary keys/foreign keys associated with the table

2016-05-07 Thread Hari Sankar Sivarama Subramaniyan 


> On May 3, 2016, 5:37 p.m., Ashutosh Chauhan wrote:
> > ql/src/test/results/clientpositive/create_with_constraints.q.out, line 137
> > 
> >
> > I think words Qualified and  child are redundant here.
> 
> Hari Sankar Sivarama Subramaniyan wrote:
> IMO Child is not redundant since this is a Parent-Child relationship. 
> Agree 'Qualified' can be omitted.
> 
> Ashutosh Chauhan wrote:
> I think child is also redundant because its a describe statement on a 
> table, so its obvious that info printed is for columns belonging to this 
> table.

ok.


> On May 3, 2016, 5:37 p.m., Ashutosh Chauhan wrote:
> > ql/src/test/queries/clientpositive/create_with_constraints.q, line 17
> > 
> >
> > describe formatted should also print constraints info. can you add a 
> > test case for that as well.
> > Also for describe extended/formatted dbName.tblName;
> 
> Hari Sankar Sivarama Subramaniyan wrote:
> This required a patch of changes in the MetaDataFormatUtils class. Will 
> upload in the next patch.
> 
> Ashutosh Chauhan wrote:
> For dbName.tblName or for formatted? Either ways, its ok to do it in a 
> follow-up where we also add support for show create table.

Ashutosh, for "show create table" I will followup with a separate jira. The 
rest, I am planning to support it here.


- Hari Sankar


---
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/46671/#review131529
---


On May 5, 2016, 1:16 a.m., Hari Sankar Sivarama Subramaniyan wrote:
> 
> ---
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/46671/
> ---
> 
> (Updated May 5, 2016, 1:16 a.m.)
> 
> 
> Review request for hive and Ashutosh Chauhan.
> 
> 
> Repository: hive-git
> 
> 
> Description
> ---
> 
> Describe extended table should show the primary keys/foreign keys associated 
> with the table
> 
> 
> Diffs
> -
> 
>   itests/util/src/main/java/org/apache/hadoop/hive/ql/QTestUtil.java a6e8efa 
>   metastore/scripts/upgrade/derby/034-HIVE-13076.derby.sql b062c56 
>   metastore/scripts/upgrade/derby/hive-schema-2.1.0.derby.sql 1d00499 
>   metastore/scripts/upgrade/mssql/019-HIVE-13076.mssql.sql 00ddb73 
>   metastore/scripts/upgrade/mssql/hive-schema-2.1.0.mssql.sql 2d9cf76 
>   metastore/scripts/upgrade/mysql/034-HIVE-13076.mysql.sql c9a5e1d 
>   metastore/scripts/upgrade/mysql/hive-schema-2.1.0.mysql.sql 466e950 
>   metastore/scripts/upgrade/oracle/034-HIVE-13076.oracle.sql baf855c 
>   metastore/scripts/upgrade/oracle/hive-schema-2.1.0.oracle.sql f57e588 
>   metastore/scripts/upgrade/postgres/033-HIVE-13076.postgres.sql ec1fb48 
>   metastore/scripts/upgrade/postgres/hive-schema-2.1.0.postgres.sql e209489 
>   metastore/src/java/org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java 
> 744512f 
>   metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java 
> 5c49be9 
>   metastore/src/model/org/apache/hadoop/hive/metastore/model/MConstraint.java 
> 3806e28 
>   metastore/src/model/package.jdo b40df39 
>   ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java c4d3bfb 
>   ql/src/java/org/apache/hadoop/hive/ql/metadata/ForeignKeyInfo.java 
> PRE-CREATION 
>   ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java f4a9772 
>   ql/src/java/org/apache/hadoop/hive/ql/metadata/PrimaryKeyInfo.java 
> PRE-CREATION 
>   
> ql/src/java/org/apache/hadoop/hive/ql/metadata/formatting/JsonMetaDataFormatter.java
>  75c2dd9 
>   
> ql/src/java/org/apache/hadoop/hive/ql/metadata/formatting/MetaDataFormatUtils.java
>  e76fb91 
>   
> ql/src/java/org/apache/hadoop/hive/ql/metadata/formatting/MetaDataFormatter.java
>  55e1b3b 
>   
> ql/src/java/org/apache/hadoop/hive/ql/metadata/formatting/TextMetaDataFormatter.java
>  b5dc0b4 
>   ql/src/test/queries/clientpositive/create_with_constraints.q 0bb92e4 
>   ql/src/test/results/clientpositive/create_with_constraints.q.out 7a7a50a 
> 
> Diff: https://reviews.apache.org/r/46671/diff/
> 
> 
> Testing
> ---
> 
> 
> Thanks,
> 
> Hari Sankar Sivarama Subramaniyan
> 
>

Re: Review Request 46671: HIVE-13598 : Describe extended table should show the primary keys/foreign keys associated with the table

2016-05-07 Thread Hari Sankar Sivarama Subramaniyan 

---
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/46671/
---

(Updated May 7, 2016, 9:34 p.m.)


Review request for hive and Ashutosh Chauhan.


Changes
---

Integrated changes as per Ashutosh's comments


Repository: hive-git


Description
---

Describe extended table should show the primary keys/foreign keys associated 
with the table


Diffs (updated)
-

  itests/util/src/main/java/org/apache/hadoop/hive/ql/QTestUtil.java 9863d6c 
  metastore/scripts/upgrade/derby/034-HIVE-13076.derby.sql b062c56 
  metastore/scripts/upgrade/derby/hive-schema-2.1.0.derby.sql dc27afc 
  metastore/scripts/upgrade/mssql/019-HIVE-13076.mssql.sql 00ddb73 
  metastore/scripts/upgrade/mssql/hive-schema-2.1.0.mssql.sql d9194ff 
  metastore/scripts/upgrade/mysql/034-HIVE-13076.mysql.sql c9a5e1d 
  metastore/scripts/upgrade/mysql/hive-schema-2.1.0.mysql.sql a6b783c 
  metastore/scripts/upgrade/oracle/034-HIVE-13076.oracle.sql baf855c 
  metastore/scripts/upgrade/oracle/hive-schema-2.1.0.oracle.sql d003a16 
  metastore/scripts/upgrade/postgres/033-HIVE-13076.postgres.sql ec1fb48 
  metastore/scripts/upgrade/postgres/hive-schema-2.1.0.postgres.sql 43e984c 
  metastore/src/java/org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java 
744512f 
  metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java 5c49be9 
  metastore/src/model/org/apache/hadoop/hive/metastore/model/MConstraint.java 
3806e28 
  metastore/src/model/package.jdo b40df39 
  ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java c4d3bfb 
  ql/src/java/org/apache/hadoop/hive/ql/metadata/ForeignKeyInfo.java 
PRE-CREATION 
  ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java f4a9772 
  ql/src/java/org/apache/hadoop/hive/ql/metadata/PrimaryKeyInfo.java 
PRE-CREATION 
  
ql/src/java/org/apache/hadoop/hive/ql/metadata/formatting/JsonMetaDataFormatter.java
 75c2dd9 
  
ql/src/java/org/apache/hadoop/hive/ql/metadata/formatting/MetaDataFormatUtils.java
 e76fb91 
  
ql/src/java/org/apache/hadoop/hive/ql/metadata/formatting/MetaDataFormatter.java
 55e1b3b 
  
ql/src/java/org/apache/hadoop/hive/ql/metadata/formatting/TextMetaDataFormatter.java
 b5dc0b4 
  ql/src/test/queries/clientpositive/create_with_constraints.q 0bb92e4 
  ql/src/test/results/clientpositive/create_with_constraints.q.out 7a7a50a 

Diff: https://reviews.apache.org/r/46671/diff/


Testing
---


Thanks,

Hari Sankar Sivarama Subramaniyan

[jira] [Created] (HIVE-13715) Show create table should show the primary keys/foreign keys associated with the table

2016-05-07 Thread Hari Sankar Sivarama Subramaniyan (JIRA) 
Hari Sankar Sivarama Subramaniyan created HIVE-13715:


 Summary: Show create table should show the primary keys/foreign 
keys associated with the table
 Key: HIVE-13715
 URL: https://issues.apache.org/jira/browse/HIVE-13715
 Project: Hive
  Issue Type: Bug
Reporter: Hari Sankar Sivarama Subramaniyan
Assignee: Hari Sankar Sivarama Subramaniyan


Follow up for HIVE-13598



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)