Re: TIMESTAMP to DATE conversion for negative unix time

2015-04-01 Thread Alexander Pivovarov
fixed https://issues.apache.org/jira/browse/HIVE-10178 https://reviews.apache.org/r/32715/diff/# On Tue, Mar 31, 2015 at 11:27 PM, Alexander Pivovarov apivova...@gmail.com wrote: correction for the first example select cast(cast('1966-01-01 00:00:01' as timestamp) as date); 1966-01-02 On

[jira] [Created] (HIVE-10180) Loop optimization in ColumnArithmeticColumn.txt

2015-04-01 Thread Chengxiang Li (JIRA)
Chengxiang Li created HIVE-10180: Summary: Loop optimization in ColumnArithmeticColumn.txt Key: HIVE-10180 URL: https://issues.apache.org/jira/browse/HIVE-10180 Project: Hive Issue Type:

Re: Review Request 32715: HIVE-10178 DateWritable incorrectly calculates daysSinceEpoch for negative Unix time

2015-04-01 Thread Alexander Pivovarov
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/32715/ --- (Updated April 1, 2015, 8:22 a.m.) Review request for hive and Jason Dere.

Re: ORC separate project

2015-04-01 Thread Carl Steinbach
Hi Owen, I think you're referring to the following questions I asked last week on the PMC mailing list: 1) How much if any of the code for vectorization/sargs/ACID will migrate over to the new ORC project. 2) Will Hive contributors encounter situations where they are required to make changes to

Review Request 32715: HIVE-10178 DateWritable incorrectly calculates daysSinceEpoch for negative Unix time

2015-04-01 Thread Alexander Pivovarov
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/32715/ --- Review request for hive and Jason Dere. Bugs: HIVE-10178

TIMESTAMP to DATE conversion for negative unix time

2015-04-01 Thread Alexander Pivovarov
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

[jira] [Created] (HIVE-10178) DateWritable incorrectly calculates daysSinceEpoch for negative Unix time

2015-04-01 Thread Alexander Pivovarov (JIRA)
Alexander Pivovarov created HIVE-10178: -- Summary: DateWritable incorrectly calculates daysSinceEpoch for negative Unix time Key: HIVE-10178 URL: https://issues.apache.org/jira/browse/HIVE-10178

Re: TIMESTAMP to DATE conversion for negative unix time

2015-04-01 Thread Alexander Pivovarov
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 apivova...@gmail.com wrote: Hi Everyone I noticed interesting behaviour for timestamp to date hive type conversion for negative

[jira] [Created] (HIVE-10179) Optimization for SIMD instructions in Hive

2015-04-01 Thread Chengxiang Li (JIRA)
Chengxiang Li created HIVE-10179: Summary: Optimization for SIMD instructions in Hive Key: HIVE-10179 URL: https://issues.apache.org/jira/browse/HIVE-10179 Project: Hive Issue Type:

[jira] [Created] (HIVE-10181) CBO (Calcite Return Path): Missing types in averageTypeValueSize method in HiveRelMdSize [CBO Branch]

2015-04-01 Thread Jesus Camacho Rodriguez (JIRA)
Jesus Camacho Rodriguez created HIVE-10181: -- Summary: CBO (Calcite Return Path): Missing types in averageTypeValueSize method in HiveRelMdSize [CBO Branch] Key: HIVE-10181 URL:

[jira] [Created] (HIVE-10182) CBO (Calcite Return Path): Improve CBO cost related debugging messages for Join operators [CBO branch]

2015-04-01 Thread Jesus Camacho Rodriguez (JIRA)
Jesus Camacho Rodriguez created HIVE-10182: -- Summary: CBO (Calcite Return Path): Improve CBO cost related debugging messages for Join operators [CBO branch] Key: HIVE-10182 URL:

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

2015-04-01 Thread Andres.Quiroz
Dear Lefty, Thank you very much for pointing that out and for your initial pointers. Here is the missing link: ftp.parc.com/pub/torres/Hiperfuse/extended_hiperfuse.pdf Regards, Andrés -Original Message- From: Lefty Leverenz [mailto:leftylever...@gmail.com] Sent: Wednesday, April 01,

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

2015-04-01 Thread Lefty Leverenz
Andrés, I followed that link and got the dread 404 Not Found: The requested URI /pub/torres/Hiperfuse/extended_hiperfuse.pdf was not found on this server. -- Lefty On Wed, Apr 1, 2015 at 7:23 PM, andres.qui...@parc.com wrote: Dear Lefty, Thank you very much for pointing that out and for

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

2015-04-01 Thread Szehon Ho
From Hive side, there has been some thought on the subject here: https://cwiki.apache.org/confluence/display/Hive/Theta+Join, it has some ideas but nobody has gotten around to giving it a try. It might be of interest. Thanks Szehon On Wed, Apr 1, 2015 at 10:05 PM, Lefty Leverenz

[jira] [Created] (HIVE-10189) Create a micro benchmark tool for vectorization to evaluate the performance gain after SIMI optimization

2015-04-01 Thread Ferdinand Xu (JIRA)
Ferdinand Xu created HIVE-10189: --- Summary: Create a micro benchmark tool for vectorization to evaluate the performance gain after SIMI optimization Key: HIVE-10189 URL:

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

2015-04-01 Thread Lefty Leverenz
D'oh! Thanks Chao. -- Lefty On Thu, Apr 2, 2015 at 12:59 AM, Chao Sun c...@cloudera.com wrote: Hey Lefty, You need to use the ftp protocol, not http. After clicking the link, you'll need to remove http://; from the address bar. Best, Chao On Wed, Apr 1, 2015 at 9:41 PM, Lefty

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

2015-04-01 Thread Brock Noland
Nice, it'd be great if someone finally implemented this :) On Wed, Apr 1, 2015 at 10:10 PM, Szehon Ho sze...@cloudera.com wrote: From Hive side, there has been some thought on the subject here: https://cwiki.apache.org/confluence/display/Hive/Theta+Join, it has some ideas but nobody has gotten

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

2015-04-01 Thread Chao Sun
Hey Lefty, You need to use the ftp protocol, not http. After clicking the link, you'll need to remove http://; from the address bar. Best, Chao On Wed, Apr 1, 2015 at 9:41 PM, Lefty Leverenz leftylever...@gmail.com wrote: Andrés, I followed that link and got the dread 404 Not Found: The

[jira] [Created] (HIVE-10190) CBO: AST mode checks for TABLESAMPLE with AST.toString().contains(TOK_TABLESPLITSAMPLE)

2015-04-01 Thread Gopal V (JIRA)
Gopal V created HIVE-10190: -- Summary: CBO: AST mode checks for TABLESAMPLE with AST.toString().contains(TOK_TABLESPLITSAMPLE) Key: HIVE-10190 URL: https://issues.apache.org/jira/browse/HIVE-10190 Project:

hive 0.14 on some platform return some not NULL value as NULL

2015-04-01 Thread r7raul1...@163.com
I use hive 1.1.0 cli on computer A (linux) the result is 87FQEZT1UEDXJHJQPFFX7G7ET8S2DVPM2357378283356 9150119100048 7326356 NULL 87FQEZT1UEDXJHJQPFFX7G7ET8S2DVPM2357378283356 121501191035580028 7326356 NULL

Re: ORC separate project

2015-04-01 Thread Owen O'Malley
On Wed, Apr 1, 2015 at 10:10 AM, Alan Gates alanfga...@gmail.com wrote: Carl Steinbach cwsteinb...@gmail.com April 1, 2015 at 0:01 Hi Owen, I think you're referring to the following questions I asked last week on the PMC mailing list: 1) How much if any of the code for

Re: ORC separate project

2015-04-01 Thread Alan Gates
Carl Steinbach mailto:cwsteinb...@gmail.com April 1, 2015 at 0:01 Hi Owen, I think you're referring to the following questions I asked last week on the PMC mailing list: 1) How much if any of the code for vectorization/sargs/ACID will migrate over to the new ORC project. 2) Will Hive

Review Request 32732: HIVE-3378 UDF to obtain the numeric day of an year from date or timestamp in HIVE

2015-04-01 Thread Alexander Pivovarov
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/32732/ --- Review request for hive and Jason Dere. Bugs: HIVE-3378

Re: ORC separate project

2015-04-01 Thread Nick Dimiduk
I think the storage-api would be very helpful for HBase integration as well. On Wed, Apr 1, 2015 at 11:22 AM, Owen O'Malley omal...@apache.org wrote: On Wed, Apr 1, 2015 at 10:10 AM, Alan Gates alanfga...@gmail.com wrote: Carl Steinbach cwsteinb...@gmail.com April 1, 2015 at 0:01 Hi

Is it necessary to update beelinepositive q.out files?

2015-04-01 Thread Alexander Pivovarov
Hello Everyone I'm working on fixing groupby3_map.q query https://issues.apache.org/jira/browse/HIVE-10168 I already updated clientpositive and clientpositive/spark q.out files Is it necessary to update beelinepositive q.out file? Most of the beelinepositive q.out files were updated 2 years

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

2015-04-01 Thread Alexander Pivovarov
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/32712/ --- (Updated April 1, 2015, 7:01 p.m.) Review request for hive and Xuefu Zhang.

[jira] [Created] (HIVE-10185) LLAP: LLAP IO doesn't get invoked inside MiniTezCluster q tests

2015-04-01 Thread Sergey Shelukhin (JIRA)
Sergey Shelukhin created HIVE-10185: --- Summary: LLAP: LLAP IO doesn't get invoked inside MiniTezCluster q tests Key: HIVE-10185 URL: https://issues.apache.org/jira/browse/HIVE-10185 Project: Hive

Re: Review Request 32715: HIVE-10178 DateWritable incorrectly calculates daysSinceEpoch for negative Unix time

2015-04-01 Thread Alexander Pivovarov
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/32715/ --- (Updated April 1, 2015, 10:01 p.m.) Review request for hive and Jason Dere.

[jira] [Created] (HIVE-10186) Hive does not log Tez diagnostics on errors

2015-04-01 Thread Hitesh Shah (JIRA)
Hitesh Shah created HIVE-10186: -- Summary: Hive does not log Tez diagnostics on errors Key: HIVE-10186 URL: https://issues.apache.org/jira/browse/HIVE-10186 Project: Hive Issue Type: Bug

[jira] [Created] (HIVE-10187) Avro backed tables don't handle cyclical or recursive records

2015-04-01 Thread Mark Wagner (JIRA)
Mark Wagner created HIVE-10187: -- Summary: Avro backed tables don't handle cyclical or recursive records Key: HIVE-10187 URL: https://issues.apache.org/jira/browse/HIVE-10187 Project: Hive

[jira] [Created] (HIVE-10188) LLAP: Failures from TaskRunnerCallable should be reported

2015-04-01 Thread Siddharth Seth (JIRA)
Siddharth Seth created HIVE-10188: - Summary: LLAP: Failures from TaskRunnerCallable should be reported Key: HIVE-10188 URL: https://issues.apache.org/jira/browse/HIVE-10188 Project: Hive

[jira] [Created] (HIVE-10183) [CBO] self-join failing in a test case

2015-04-01 Thread Ashutosh Chauhan (JIRA)
Ashutosh Chauhan created HIVE-10183: --- Summary: [CBO] self-join failing in a test case Key: HIVE-10183 URL: https://issues.apache.org/jira/browse/HIVE-10183 Project: Hive Issue Type: Bug

[jira] [Created] (HIVE-10184) Add -- SORT_BEOFRE_DIFF for cbo join test

2015-04-01 Thread Ashutosh Chauhan (JIRA)
Ashutosh Chauhan created HIVE-10184: --- Summary: Add -- SORT_BEOFRE_DIFF for cbo join test Key: HIVE-10184 URL: https://issues.apache.org/jira/browse/HIVE-10184 Project: Hive Issue Type: Bug

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

2015-04-01 Thread Jason Dere
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/32324/ --- (Updated April 1, 2015, 9:07 p.m.) Review request for hive, Ashutosh Chauhan

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

2015-04-01 Thread Jason Dere
On April 1, 2015, 1:34 a.m., Thejas Nair wrote: jdbc/src/java/org/apache/hive/jdbc/JdbcColumn.java, line 167 https://reviews.apache.org/r/32324/diff/2/?file=901924#file901924line167 can we re-use typeStringToHiveType here ? I see void and null as only things that need to be