Cursor implementation in hive

2017-07-31 Thread elango vaidyanathan
Hi all, I need to convert a SQL functionality that is in oracle now to hive Existing pl/sql sudo code: /* using cursor, column1 value is updated based on various if condition checks */ Open cursor<> If () Update table column1 with value 1 Else if () Update table column1 with value 2

[GitHub] hive pull request #215: HIVE-17144 : export of temporary tables not working ...

2017-07-31 Thread anishek
GitHub user anishek opened a pull request: https://github.com/apache/hive/pull/215 HIVE-17144 : export of temporary tables not working and it seems to be using distcp rather than filesystem copy You can merge this pull request into a Git repository by running: $ git pull

[GitHub] hive pull request #214: Hive 16896: move replication load related work in se...

2017-07-31 Thread anishek
GitHub user anishek opened a pull request: https://github.com/apache/hive/pull/214 Hive 16896: move replication load related work in semantic analysis phase to execution phase using a task You can merge this pull request into a Git repository by running: $ git pull

[jira] [Created] (HIVE-17221) Error: Error while compiling statement: FAILED: IndexOutOfBoundsException Index: 4, Size: 2 (state=42000,code=40000)

2017-07-31 Thread Matan Vardi (JIRA)
Matan Vardi created HIVE-17221: -- Summary: Error: Error while compiling statement: FAILED: IndexOutOfBoundsException Index: 4, Size: 2 (state=42000,code=4) Key: HIVE-17221 URL:

[jira] [Created] (HIVE-17220) Bloomfilter probing in semijoin reduction is thrashing L1 dcache

2017-07-31 Thread Prasanth Jayachandran (JIRA)
Prasanth Jayachandran created HIVE-17220: Summary: Bloomfilter probing in semijoin reduction is thrashing L1 dcache Key: HIVE-17220 URL: https://issues.apache.org/jira/browse/HIVE-17220

[jira] [Created] (HIVE-17219) NPE in SparkPartitionPruningSinkOperator#closeOp for query with partitioned join in subquery

2017-07-31 Thread Sahil Takiar (JIRA)
Sahil Takiar created HIVE-17219: --- Summary: NPE in SparkPartitionPruningSinkOperator#closeOp for query with partitioned join in subquery Key: HIVE-17219 URL: https://issues.apache.org/jira/browse/HIVE-17219

[jira] [Created] (HIVE-17218) Canonical-ize hostnames for Hive metastore, and HS2 servers.

2017-07-31 Thread Mithun Radhakrishnan (JIRA)
Mithun Radhakrishnan created HIVE-17218: --- Summary: Canonical-ize hostnames for Hive metastore, and HS2 servers. Key: HIVE-17218 URL: https://issues.apache.org/jira/browse/HIVE-17218 Project:

[jira] [Created] (HIVE-17217) Bucket Map Join : Assert if paths are different in TezGroupedSplit in KeyValueInputMerger

2017-07-31 Thread Deepak Jaiswal (JIRA)
Deepak Jaiswal created HIVE-17217: - Summary: Bucket Map Join : Assert if paths are different in TezGroupedSplit in KeyValueInputMerger Key: HIVE-17217 URL: https://issues.apache.org/jira/browse/HIVE-17217

[jira] [Created] (HIVE-17216) Additional qtests for HoS DPP

2017-07-31 Thread Sahil Takiar (JIRA)
Sahil Takiar created HIVE-17216: --- Summary: Additional qtests for HoS DPP Key: HIVE-17216 URL: https://issues.apache.org/jira/browse/HIVE-17216 Project: Hive Issue Type: Sub-task

[jira] [Created] (HIVE-17215) Streaming Ingest API writing unbucketed tables

2017-07-31 Thread Eugene Koifman (JIRA)
Eugene Koifman created HIVE-17215: - Summary: Streaming Ingest API writing unbucketed tables Key: HIVE-17215 URL: https://issues.apache.org/jira/browse/HIVE-17215 Project: Hive Issue Type:

[jira] [Created] (HIVE-17214) check/fix conversion of non-acid to acid

2017-07-31 Thread Eugene Koifman (JIRA)
Eugene Koifman created HIVE-17214: - Summary: check/fix conversion of non-acid to acid Key: HIVE-17214 URL: https://issues.apache.org/jira/browse/HIVE-17214 Project: Hive Issue Type: Sub-task

[jira] [Created] (HIVE-17213) HoS: file merging doesn't work for union all

2017-07-31 Thread Chao Sun (JIRA)
Chao Sun created HIVE-17213: --- Summary: HoS: file merging doesn't work for union all Key: HIVE-17213 URL: https://issues.apache.org/jira/browse/HIVE-17213 Project: Hive Issue Type: Bug

[GitHub] hive pull request #213: Dynamic add partition by insert shouldn't generate I...

2017-07-31 Thread sankarh
GitHub user sankarh opened a pull request: https://github.com/apache/hive/pull/213 Dynamic add partition by insert shouldn't generate INSERT event. You can merge this pull request into a Git repository by running: $ git pull https://github.com/sankarh/hive HIVE-17212

[jira] [Created] (HIVE-17212) Dynamic add partition by insert shouldn't generate INSERT event.

2017-07-31 Thread Sankar Hariappan (JIRA)
Sankar Hariappan created HIVE-17212: --- Summary: Dynamic add partition by insert shouldn't generate INSERT event. Key: HIVE-17212 URL: https://issues.apache.org/jira/browse/HIVE-17212 Project: Hive

Re: Review Request 61250: HIVE-17211:SQLStdHiveAccessController.showPrivileges Method may encountered Null pointer

2017-07-31 Thread hongtaq zhao
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/61250/ --- (Updated 七月 31, 2017, 11:29 a.m.) Review request for hive. Bugs: HIVE-17211

Review Request 61250: HIVE-17211:SQLStdHiveAccessController.showPrivileges Method may encountered Null pointer

2017-07-31 Thread hongtaq zhao
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/61250/ --- Review request for hive. Bugs:

[jira] [Created] (HIVE-17211) SQLStdHiveAccessController.showPrivileges Method may encountered 遇到空指针 Null pointer

2017-07-31 Thread zhaohongtao (JIRA)
zhaohongtao created HIVE-17211: -- Summary: SQLStdHiveAccessController.showPrivileges Method may encountered 遇到空指针 Null pointer Key: HIVE-17211 URL: https://issues.apache.org/jira/browse/HIVE-17211

[jira] [Created] (HIVE-17210) Failed With Exception java.io.IOException:java.lang.ArrayIndexOutOfBoundsException: 1 Using Java UDTF for Hive

2017-07-31 Thread Saihiel Bakshi (JIRA)
Saihiel Bakshi created HIVE-17210: - Summary: Failed With Exception java.io.IOException:java.lang.ArrayIndexOutOfBoundsException: 1 Using Java UDTF for Hive Key: HIVE-17210 URL:

Re: Review Request 60085: HIVE-14747: Remove JAVA paths from profiles by sending them from ptest-client

2017-07-31 Thread Barna Zsombor Klara
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/60085/ --- (Updated July 31, 2017, 8:05 a.m.) Review request for hive, Marta Kuczora,