Re: TIMESTAMP to DATE conversion for negative unix time

correction for the first example select cast(cast('1966-01-01 00:00:01' as timestamp) as date); 1966-01-02 On Tue, Mar 31, 2015 at 11:26 PM, Alexander Pivovarov wrote: > Hi Everyone > > I noticed interesting behaviour for timestamp to date hive type conversion > for negative unix time. > > For

TIMESTAMP to DATE conversion for negative unix time

Hi Everyone I noticed interesting behaviour for timestamp to date hive type conversion for negative unix time. For example: select cast(cast('1966-01-01 00:00:01' as timestamp) as date); 1966-02-02 Should it work this way? Another example select last_day(cast('1966-01-31 00:00:01' as timestamp

[jira] [Created] (HIVE-10177) Enable constant folding for char & varchar

Ashutosh Chauhan created HIVE-10177: --- Summary: Enable constant folding for char & varchar Key: HIVE-10177 URL: https://issues.apache.org/jira/browse/HIVE-10177 Project: Hive Issue Type: Imp

[jira] [Created] (HIVE-10176) skip.header.line.count causes values to be skipped when performing insert values

Wenbo Wang created HIVE-10176: - Summary: skip.header.line.count causes values to be skipped when performing insert values Key: HIVE-10176 URL: https://issues.apache.org/jira/browse/HIVE-10176 Project: Hiv

Re: Request for feedback on work intent for non-equijoin support

Hello Andres, the link to your paper is missing: In our preliminary work, which you can find here (pointer to the paper) ... You can find general information about contributing to Hive in the wiki: Resources for Contributors

Re: Review Request 32712: HIVE-10168 make groupby3_map.q more stable

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/32712/ --- (Updated April 1, 2015, 4:19 a.m.) Review request for hive and Xuefu Zhang. B

Review Request 32712: HIVE-10168 make groupby3_map.q more stable

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/32712/ --- Review request for hive. Repository: hive-git Description --- HIVE-10168

[jira] [Created] (HIVE-10175) Tez DynamicPartitionPruning lacks a fast-path exit for large IN() queries

Gopal V created HIVE-10175: -- Summary: Tez DynamicPartitionPruning lacks a fast-path exit for large IN() queries Key: HIVE-10175 URL: https://issues.apache.org/jira/browse/HIVE-10175 Project: Hive I

[jira] [Created] (HIVE-10174) LLAP: ORC MemoryManager is singleton synchronized

Gopal V created HIVE-10174: -- Summary: LLAP: ORC MemoryManager is singleton synchronized Key: HIVE-10174 URL: https://issues.apache.org/jira/browse/HIVE-10174 Project: Hive Issue Type: Sub-task

[jira] [Created] (HIVE-10173) ThreadLocal synchronized initialvalue() is irrelevant in JDK7

Gopal V created HIVE-10173: -- Summary: ThreadLocal synchronized initialvalue() is irrelevant in JDK7 Key: HIVE-10173 URL: https://issues.apache.org/jira/browse/HIVE-10173 Project: Hive Issue Type: B

Request for feedback on work intent for non-equijoin support

Dear Hive development community members, I am interested in learning more about the current support for non-equijoins in Hive and/or other Hadoop SQL engines, and in getting feedback about community interest in more extensive support for such a feature. I intend to work on this challenge, assum

Re: Review Request 32324: HIVE-10037 JDBC support for interval expressions

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/32324/#review78462 --- jdbc/src/java/org/apache/hive/jdbc/JdbcColumn.java

[jira] [Created] (HIVE-10172) Fix performance regression caused by HIVE-8122 for ORC

Prasanth Jayachandran created HIVE-10172: Summary: Fix performance regression caused by HIVE-8122 for ORC Key: HIVE-10172 URL: https://issues.apache.org/jira/browse/HIVE-10172 Project: Hive

[jira] [Created] (HIVE-10171) Create a storage-api module

Owen O'Malley created HIVE-10171: Summary: Create a storage-api module Key: HIVE-10171 URL: https://issues.apache.org/jira/browse/HIVE-10171 Project: Hive Issue Type: Bug Reporter

Re: ORC separate project

All, Moving this forward, I'll submit a resolution to the Apache board for the next meeting. One of the concerns that has been mentioned is how to deal with the vectorization and SARG APIs. I'd like to propose that we pull the minimal set of classes in a new Hive module named "storage-api". This

[jira] [Created] (HIVE-10170) LLAP: general cache deadlock avoidance

Sergey Shelukhin created HIVE-10170: --- Summary: LLAP: general cache deadlock avoidance Key: HIVE-10170 URL: https://issues.apache.org/jira/browse/HIVE-10170 Project: Hive Issue Type: Sub-tas

Re: Review Request 32489: HIVE-9518 Implement MONTHS_BETWEEN aligned with Oracle one

> On March 31, 2015, 8:47 p.m., Mohit Sabharwal wrote: > > ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFMonthsBetween.java, > > line 131 > > > > > > nit: cleaner to just say (31 * 24 * 60 * 60) added S

Re: Review Request 32489: HIVE-9518 Implement MONTHS_BETWEEN aligned with Oracle one

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/32489/ --- (Updated March 31, 2015, 9:32 p.m.) Review request for hive and Jason Dere. C

Re: Review Request 32489: HIVE-9518 Implement MONTHS_BETWEEN aligned with Oracle one

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/32489/#review78395 --- ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFMonthsB

Re: Hive 1.2

+1 Thanks for volunteering Sushanth! On Mon, Mar 30, 2015 at 10:02 AM, Sushanth Sowmyan wrote: > Hi Folks, > > Given that we landed a bunch of changes in trunk shooting for 1.2 > after 1.1 was forked off, including some metastore changes, I propose > that we have a feature rollup release of hive

Re: Review Request 32489: HIVE-9518 Implement MONTHS_BETWEEN aligned with Oracle one

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/32489/ --- (Updated March 31, 2015, 8:08 p.m.) Review request for hive and Jason Dere. C

Re: Hive 1.2

Okay. Makes sense. Thanks, Xuefu On Tue, Mar 31, 2015 at 11:38 AM, Thejas Nair wrote: > Xuefu, > Releases such as 1.1.1 are by convention bug fix releases, and only > include a selected set of important bug fixes that have been applied > to the release branch (branch-1.1 in this case). > > In t

[jira] [Created] (HIVE-10169) get metatool to work with hbase metastore

Thejas M Nair created HIVE-10169: Summary: get metatool to work with hbase metastore Key: HIVE-10169 URL: https://issues.apache.org/jira/browse/HIVE-10169 Project: Hive Issue Type: Sub-task

Re: Hive 1.2

Xuefu, Releases such as 1.1.1 are by convention bug fix releases, and only include a selected set of important bug fixes that have been applied to the release branch (branch-1.1 in this case). In the 2 months since the creation of branch-1.0, we have around 211 jiras that have been committed in tr

Re: Review Request 32637: HIVE-10128 LLAP: BytesBytesMultiHashMap does not allow concurrent read-only access

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/32637/ --- (Updated March 31, 2015, 6:19 p.m.) Review request for hive, Ashutosh Chauhan a

[jira] [Created] (HIVE-10168) make groupby3_map.q more stable

Alexander Pivovarov created HIVE-10168: -- Summary: make groupby3_map.q more stable Key: HIVE-10168 URL: https://issues.apache.org/jira/browse/HIVE-10168 Project: Hive Issue Type: Bug

[jira] [Created] (HIVE-10167) HS2 logs the server started only before the server is shut down

Jimmy Xiang created HIVE-10167: -- Summary: HS2 logs the server started only before the server is shut down Key: HIVE-10167 URL: https://issues.apache.org/jira/browse/HIVE-10167 Project: Hive Iss

Re: Review Request 32692: HIVE-10083 SMBJoin fails in case one table is uninitialized

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/32692/#review78380 --- Ship it! Ship It! - Chao Sun On March 31, 2015, 5:01 p.m., Na Ya

Re: Review Request 32406: Add another level of explain for RDBMS audience

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/32406/#review78298 --- Overall looks good. Few minor code level comments. common/src/java

Hive-0.14 - Build # 910 - Fixed

Changes for Build #909 Changes for Build #910 No tests ran. The Apache Jenkins build system has built Hive-0.14 (build #910) Status: Fixed Check console output at https://builds.apache.org/job/Hive-0.14/910/ to view the results.

Review Request 32692: HIVE-10083 SMBJoin fails in case one table is uninitialized

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/32692/ --- Review request for hive, Brock Noland, Chao Sun, and Xuefu Zhang. Bugs: 10083

Re: Review Request 32370: HIVE-10040

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/32370/#review78367 --- ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/cost/HiveDe

Re: Hive 1.2

Hi Sushanth, Thanks for starting this. Rapid releasing is good. However, could you please provide a list of major changes or enhancement? I'd like to see whether we are in position to release it as 1.1.1 or 1.2.0. Thanks, Xuefu On Mon, Mar 30, 2015 at 10:02 AM, Sushanth Sowmyan wrote: > Hi Fo

[jira] [Created] (HIVE-10166) Merge Spark branch to trunk 3/31/2015

Xuefu Zhang created HIVE-10166: -- Summary: Merge Spark branch to trunk 3/31/2015 Key: HIVE-10166 URL: https://issues.apache.org/jira/browse/HIVE-10166 Project: Hive Issue Type: Sub-task

[jira] [Created] (HIVE-10165) Improve hive-hcatalog-streaming extensibility and support updates and deletes.

Elliot West created HIVE-10165: -- Summary: Improve hive-hcatalog-streaming extensibility and support updates and deletes. Key: HIVE-10165 URL: https://issues.apache.org/jira/browse/HIVE-10165 Project: Hiv

[jira] [Created] (HIVE-10164) LLAP: ORC BIGINT SARGs regressed after Parquet PPD fixes (HIVE-8122)

Gopal V created HIVE-10164: -- Summary: LLAP: ORC BIGINT SARGs regressed after Parquet PPD fixes (HIVE-8122) Key: HIVE-10164 URL: https://issues.apache.org/jira/browse/HIVE-10164 Project: Hive Issue

[jira] [Created] (HIVE-10163) CommonMergeJoinOperator calls WritableComparator.get() in the inner loop

Gopal V created HIVE-10163: -- Summary: CommonMergeJoinOperator calls WritableComparator.get() in the inner loop Key: HIVE-10163 URL: https://issues.apache.org/jira/browse/HIVE-10163 Project: Hive Is

[jira] [Created] (HIVE-10162) LLAP: Avoid deserializing the plan > 1 times in a single thread

Gopal V created HIVE-10162: -- Summary: LLAP: Avoid deserializing the plan > 1 times in a single thread Key: HIVE-10162 URL: https://issues.apache.org/jira/browse/HIVE-10162 Project: Hive Issue Type:

[jira] [Created] (HIVE-10161) LLAP: IO buffers seem to be hard-coded to 256kb

Gopal V created HIVE-10161: -- Summary: LLAP: IO buffers seem to be hard-coded to 256kb Key: HIVE-10161 URL: https://issues.apache.org/jira/browse/HIVE-10161 Project: Hive Issue Type: Sub-task Af