Re: Review Request 44524: HIVE-11484 : Fix ObjectInspector for Char and VarChar

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/44524/#review122697 --- Ship it! Ship It! - Rajat Khandelwal On March 9, 2016, 12:47

SELECT without FROM

I noticed that Hive allows you to execute SELECT without FROM clause (tested in Hive 0.14, Hive 1.2.1): SELECT 1+1; In which version was it added (is there a Jira)? I see that it is not mentioned in docs https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Select So the question wheth

Re: SELECT without FROM

Mich, I now that. I just want to trace when it was added to Hive. Dmitry On Wed, Mar 9, 2016 at 12:56 PM, Mich Talebzadeh wrote: > ASAIK any database does that! > > 1> set nocount on > 2> select @@version > 3> select 1 + 1 > 4> go > > > > > ---

Re: SELECT without FROM

Not sure. It does not work in my Hive 0.13 version. On Wed, Mar 9, 2016 at 1:06 PM, Mich Talebzadeh wrote: > I believe it has always been there > > Dr Mich Talebzadeh > > > > LinkedIn * > https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw >

Re: Review Request 44453: HIVE-4570: More information to user on GetOperationStatus in Hive Server2 when query is still executing

> On March 8, 2016, 3:36 a.m., Szehon Ho wrote: > > Thanks for fixing those earlier items. > > > > I am still worried that getOperationStatus will be called by another thrift > > thread at any time. Don't we need to synchronize/protect all the fields > > that it accesses, like the OperationSt

Re: Review Request 44453: HIVE-4570: More information to user on GetOperationStatus in Hive Server2 when query is still executing

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/44453/ --- (Updated March 9, 2016, 8:33 p.m.) Review request for hive, Amareshwari Srirama

Re: Review Request 44453: HIVE-4570: More information to user on GetOperationStatus in Hive Server2 when query is still executing

> On March 8, 2016, 3:36 a.m., Szehon Ho wrote: > > Thanks for fixing those earlier items. > > > > I am still worried that getOperationStatus will be called by another thrift > > thread at any time. Don't we need to synchronize/protect all the fields > > that it accesses, like the OperationSt

Re: SELECT without FROM

I’m not aware of any JIRA on it. The easiest way to find out will be to look at the git history of Hive’s grammar file and see when it changed. As for taking out, we shouldn’t since it’s valid SQL and we’re pushing towards more ANSI compliance. Alan. > On Mar 9, 2016, at 01:50, Dmitry Tolpeko

[jira] [Created] (HIVE-13242) DISTINCT keyword is dropped by the parser for windowing

Jesus Camacho Rodriguez created HIVE-13242: -- Summary: DISTINCT keyword is dropped by the parser for windowing Key: HIVE-13242 URL: https://issues.apache.org/jira/browse/HIVE-13242 Project: Hiv

[jira] [Created] (HIVE-13243) Hive drop table on encyption zone fails for external tables

Chaoyu Tang created HIVE-13243: -- Summary: Hive drop table on encyption zone fails for external tables Key: HIVE-13243 URL: https://issues.apache.org/jira/browse/HIVE-13243 Project: Hive Issue T

Re: SELECT without FROM

Thanks, Alan. We should document this as well, now the syntax at https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Select states that FROM is mandatory. Dmitry On Wed, Mar 9, 2016 at 6:46 PM, Alan Gates wrote: > I’m not aware of any JIRA on it. The easiest way to find out will be

[jira] [Created] (HIVE-13244) Get 'test-query-redactor.json' file on TestQueryRedactor.java from the resources classpath

Sergio Peña created HIVE-13244: -- Summary: Get 'test-query-redactor.json' file on TestQueryRedactor.java from the resources classpath Key: HIVE-13244 URL: https://issues.apache.org/jira/browse/HIVE-13244

[jira] [Created] (HIVE-13245) VectorDeserializeRow throws IndexOutOfBoundsException

Prasanth Jayachandran created HIVE-13245: Summary: VectorDeserializeRow throws IndexOutOfBoundsException Key: HIVE-13245 URL: https://issues.apache.org/jira/browse/HIVE-13245 Project: Hive

Re: Review Request 44491: HIVE-13221 expose metastore APIs from HS2

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/44491/ --- (Updated March 9, 2016, 7:29 p.m.) Review request for hive, Ashutosh Chauhan, S

[jira] [Created] (HIVE-13246) Add log line to ORC writer to print out the file path

Prasanth Jayachandran created HIVE-13246: Summary: Add log line to ORC writer to print out the file path Key: HIVE-13246 URL: https://issues.apache.org/jira/browse/HIVE-13246 Project: Hive

[jira] [Created] (HIVE-13247) HIVE-13040 broke spark tests

Sergey Shelukhin created HIVE-13247: --- Summary: HIVE-13040 broke spark tests Key: HIVE-13247 URL: https://issues.apache.org/jira/browse/HIVE-13247 Project: Hive Issue Type: Bug R

[jira] [Created] (HIVE-13248) Change date_add/date_sub/to_date functions to return Date type rather than String

Jason Dere created HIVE-13248: - Summary: Change date_add/date_sub/to_date functions to return Date type rather than String Key: HIVE-13248 URL: https://issues.apache.org/jira/browse/HIVE-13248 Project: Hi

[jira] [Created] (HIVE-13249) Hard upper bound on number of open transactions

Wei Zheng created HIVE-13249: Summary: Hard upper bound on number of open transactions Key: HIVE-13249 URL: https://issues.apache.org/jira/browse/HIVE-13249 Project: Hive Issue Type: Bug

Re: Review Request 43626: HIVE-12988

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/43626/ --- (Updated March 9, 2016, 9:35 p.m.) Review request for hive and Prasanth_J. Ch

[jira] [Created] (HIVE-13250) Compute predicate conversions on the client, instead of per row group

Siddharth Seth created HIVE-13250: - Summary: Compute predicate conversions on the client, instead of per row group Key: HIVE-13250 URL: https://issues.apache.org/jira/browse/HIVE-13250 Project: Hive

[jira] [Created] (HIVE-13251) Decimal in AVRO file generated from previous hive can't be read

Aihua Xu created HIVE-13251: --- Summary: Decimal in AVRO file generated from previous hive can't be read Key: HIVE-13251 URL: https://issues.apache.org/jira/browse/HIVE-13251 Project: Hive Issue Ty

[jira] [Created] (HIVE-13252) Reenable authorization_uri_import.q test

Ashutosh Chauhan created HIVE-13252: --- Summary: Reenable authorization_uri_import.q test Key: HIVE-13252 URL: https://issues.apache.org/jira/browse/HIVE-13252 Project: Hive Issue Type: Bug

[jira] [Created] (HIVE-13253) Reenable TestSSL#testSSLVersion

Ashutosh Chauhan created HIVE-13253: --- Summary: Reenable TestSSL#testSSLVersion Key: HIVE-13253 URL: https://issues.apache.org/jira/browse/HIVE-13253 Project: Hive Issue Type: Task

[ANNOUNCE] New Hive Committer - Wei Zheng

The Apache Hive PMC has voted to make Wei Zheng a committer on the Apache Hive Project. Please join me in congratulating Wei. Thanks Vikram.

[jira] [Created] (HIVE-13254) GBY cardinality estimation is wrong partition columns is involved

Prasanth Jayachandran created HIVE-13254: Summary: GBY cardinality estimation is wrong partition columns is involved Key: HIVE-13254 URL: https://issues.apache.org/jira/browse/HIVE-13254 Proje

Re: Review Request 44453: HIVE-4570: More information to user on GetOperationStatus in Hive Server2 when query is still executing

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/44453/#review122853 --- Ship it! Yes you were right that in the original patch, rootTas

Re: [ANNOUNCE] New Hive Committer - Wei Zheng

Congratulations Wei! On Wed, Mar 9, 2016 at 5:26 PM, Vikram Dixit K wrote: > The Apache Hive PMC has voted to make Wei Zheng a committer on the Apache > Hive Project. Please join me in congratulating Wei. > > Thanks > Vikram. >

[jira] [Created] (HIVE-13255) FloatTreeReader.nextVector is expensive

Prasanth Jayachandran created HIVE-13255: Summary: FloatTreeReader.nextVector is expensive Key: HIVE-13255 URL: https://issues.apache.org/jira/browse/HIVE-13255 Project: Hive Issue T

[jira] [Created] (HIVE-13256) LLAP: RowGroup counter is wrong

Prasanth Jayachandran created HIVE-13256: Summary: LLAP: RowGroup counter is wrong Key: HIVE-13256 URL: https://issues.apache.org/jira/browse/HIVE-13256 Project: Hive Issue Type: Bug

[jira] [Created] (HIVE-13257) GroupBy with column alias does not support AVG

Prasanth Jayachandran created HIVE-13257: Summary: GroupBy with column alias does not support AVG Key: HIVE-13257 URL: https://issues.apache.org/jira/browse/HIVE-13257 Project: Hive I

Re: [ANNOUNCE] New Hive Committer - Wei Zheng

Congratulations Wei! On Mar 9, 2016, at 8:43 PM, Sergey Shelukhin mailto:ser...@hortonworks.com>> wrote: Congrats! From: Szehon Ho mailto:sze...@cloudera.com>> Reply-To: "u...@hive.apache.org" mailto:u...@hive.apache.org>> Date: Wednesday, March 9, 2016 at 17:40 To

Re: [ANNOUNCE] New Hive Committer - Wei Zheng

Congrats! From: Szehon Ho mailto:sze...@cloudera.com>> Reply-To: "u...@hive.apache.org" mailto:u...@hive.apache.org>> Date: Wednesday, March 9, 2016 at 17:40 To: "u...@hive.apache.org" mailto:u...@hive.apache.org>> Cc: "dev@hive.apache.or

Re: [ANNOUNCE] New Hive Committer - Wei Zheng

Congratulations! On Wed, Mar 9, 2016 at 6:44 PM, Prasanth Jayachandran < pjayachand...@hortonworks.com> wrote: > Congratulations Wei! > > On Mar 9, 2016, at 8:43 PM, Sergey Shelukhin > wrote: > > Congrats! > > From: Szehon Ho mailto:sze...@cloudera.com>> > Reply-To

[jira] [Created] (HIVE-13258) LLAP: Add hdfs bytes read and spilled bytes to tez print summary

Prasanth Jayachandran created HIVE-13258: Summary: LLAP: Add hdfs bytes read and spilled bytes to tez print summary Key: HIVE-13258 URL: https://issues.apache.org/jira/browse/HIVE-13258 Projec

Re: [ANNOUNCE] New Hive Committer - Wei Zheng

Congratulations, Wei! On Wed, Mar 9, 2016 at 6:48 PM, Chao Sun wrote: > Congratulations! > > On Wed, Mar 9, 2016 at 6:44 PM, Prasanth Jayachandran < > pjayachand...@hortonworks.com> wrote: > > > Congratulations Wei! > > > > On Mar 9, 2016, at 8:43 PM, Sergey Shelukhin >

Re: Review Request 44453: HIVE-4570: More information to user on GetOperationStatus in Hive Server2 when query is still executing

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/44453/#review122876 --- service/src/java/org/apache/hive/service/cli/thrift/ThriftCLIServ

Re: Review Request 44416: Authorization issues with cascading views

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/44416/ --- (Updated March 10, 2016, 5:29 a.m.) Review request for hive and Ashutosh Chauha

Review Request 44608: HIVE-4570: More information to user on GetOperationStatus in Hive Server2 when query is still executing

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/44608/ --- Review request for hive. Bugs: HIVE-4570 https://issues.apache.org/jira/bro

Re: [ANNOUNCE] New Hive Committer - Wei Zheng

Congratulations, Wei! On Thu, Mar 10, 2016 at 5:48 AM, Chao Sun wrote: > Congratulations! > > On Wed, Mar 9, 2016 at 6:44 PM, Prasanth Jayachandran < > pjayachand...@hortonworks.com> wrote: > >> Congratulations Wei! >> >> On Mar 9, 2016, at 8:43 PM, Sergey Shelukhin >

Re: [ANNOUNCE] New Hive Committer - Wei Zheng

Congratulations! -- Lefty On Wed, Mar 9, 2016 at 10:30 PM, Dmitry Tolpeko wrote: > Congratulations, Wei! > > On Thu, Mar 10, 2016 at 5:48 AM, Chao Sun wrote: > >> Congratulations! >> >> On Wed, Mar 9, 2016 at 6:44 PM, Prasanth Jayachandran < >> pjayachand...@hortonworks.com> wrote: >> >>> Cong

Re: Review Request 44453: HIVE-4570: More information to user on GetOperationStatus in Hive Server2 when query is still executing

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/44453/ --- (Updated March 10, 2016, 1:25 p.m.) Review request for hive, Amareshwari Sriram

Re: Review Request 44453: HIVE-4570: More information to user on GetOperationStatus in Hive Server2 when query is still executing

> On March 10, 2016, 10:12 a.m., Amareshwari Sriramadasu wrote: > > service/src/java/org/apache/hive/service/cli/thrift/ThriftCLIService.java, > > line 682 > > > > > > Is set on start and completion times not requir