[jira] [Commented] (HIVE-8155) In select statement after * any random characters are allowed in hive but in RDBMS its not allowed

2014-12-30 Thread Lefty Leverenz (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-8155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14260924#comment-14260924
 ] 

Lefty Leverenz commented on HIVE-8155:
--

Doc note:  This can be documented (with release information) in the Simple 
query bullet after the SELECT syntax.

* [Select Syntax | 
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Select#LanguageManualSelect-SelectSyntax]

  In select statement after * any random characters are allowed in hive but in 
 RDBMS its not allowed
 ---

 Key: HIVE-8155
 URL: https://issues.apache.org/jira/browse/HIVE-8155
 Project: Hive
  Issue Type: Improvement
Reporter: Ferdinand Xu
Assignee: Dong Chen
Priority: Critical
  Labels: TODOC15
 Fix For: 0.15.0

 Attachments: HIVE-8155.1.patch, HIVE-8155.patch


 In select statement after * any random characters are allowed in hive but in 
 RDBMS its not allowed. 
 Steps:
 In the below query abcdef is random characters.
 In RDBMS(oracle): 
 select *abcdef from mytable;
 Output: 
 ERROR prepare() failed with: ORA-00923: FROM keyword not found where expected
 In Hive:
 select *abcdef from mytable;
 Output: 
 Query worked fine and display all the records of mytable.



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

[jira] [Commented] (HIVE-8155) In select statement after * any random characters are allowed in hive but in RDBMS its not allowed

2014-12-28 Thread Dong Chen (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-8155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14259792#comment-14259792
 ] 

Dong Chen commented on HIVE-8155:
-

Thanks very much for your review!! [~ashutoshc], [~sershe]

  In select statement after * any random characters are allowed in hive but in 
 RDBMS its not allowed
 ---

 Key: HIVE-8155
 URL: https://issues.apache.org/jira/browse/HIVE-8155
 Project: Hive
  Issue Type: Improvement
Reporter: Ferdinand Xu
Assignee: Dong Chen
Priority: Critical
 Attachments: HIVE-8155.1.patch, HIVE-8155.patch


 In select statement after * any random characters are allowed in hive but in 
 RDBMS its not allowed. 
 Steps:
 In the below query abcdef is random characters.
 In RDBMS(oracle): 
 select *abcdef from mytable;
 Output: 
 ERROR prepare() failed with: ORA-00923: FROM keyword not found where expected
 In Hive:
 select *abcdef from mytable;
 Output: 
 Query worked fine and display all the records of mytable.



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

[jira] [Commented] (HIVE-8155) In select statement after * any random characters are allowed in hive but in RDBMS its not allowed

2014-12-23 Thread Sergey Shelukhin (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-8155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14257395#comment-14257395
 ] 

Sergey Shelukhin commented on HIVE-8155:


lgtm provided tests pass [~ashutoshc] do you want to take a look at grammar 
change?

  In select statement after * any random characters are allowed in hive but in 
 RDBMS its not allowed
 ---

 Key: HIVE-8155
 URL: https://issues.apache.org/jira/browse/HIVE-8155
 Project: Hive
  Issue Type: Improvement
Reporter: Ferdinand Xu
Assignee: Dong Chen
Priority: Critical
 Attachments: HIVE-8155.1.patch, HIVE-8155.patch


 In select statement after * any random characters are allowed in hive but in 
 RDBMS its not allowed. 
 Steps:
 In the below query abcdef is random characters.
 In RDBMS(oracle): 
 select *abcdef from mytable;
 Output: 
 ERROR prepare() failed with: ORA-00923: FROM keyword not found where expected
 In Hive:
 select *abcdef from mytable;
 Output: 
 Query worked fine and display all the records of mytable.



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

[jira] [Commented] (HIVE-8155) In select statement after * any random characters are allowed in hive but in RDBMS its not allowed

2014-12-23 Thread Sergey Shelukhin (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-8155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14257396#comment-14257396
 ] 

Sergey Shelukhin commented on HIVE-8155:


thanks for investigating!

  In select statement after * any random characters are allowed in hive but in 
 RDBMS its not allowed
 ---

 Key: HIVE-8155
 URL: https://issues.apache.org/jira/browse/HIVE-8155
 Project: Hive
  Issue Type: Improvement
Reporter: Ferdinand Xu
Assignee: Dong Chen
Priority: Critical
 Attachments: HIVE-8155.1.patch, HIVE-8155.patch


 In select statement after * any random characters are allowed in hive but in 
 RDBMS its not allowed. 
 Steps:
 In the below query abcdef is random characters.
 In RDBMS(oracle): 
 select *abcdef from mytable;
 Output: 
 ERROR prepare() failed with: ORA-00923: FROM keyword not found where expected
 In Hive:
 select *abcdef from mytable;
 Output: 
 Query worked fine and display all the records of mytable.



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

[jira] [Commented] (HIVE-8155) In select statement after * any random characters are allowed in hive but in RDBMS its not allowed

2014-12-23 Thread Hive QA (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-8155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14257400#comment-14257400
 ] 

Hive QA commented on HIVE-8155:
---



{color:red}Overall{color}: -1 at least one tests failed

Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12688802/HIVE-8155.1.patch

{color:red}ERROR:{color} -1 due to 2 failed/errored test(s), 6721 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_lvj_mapjoin
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_optimize_nullscan
{noformat}

Test results: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2177/testReport
Console output: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2177/console
Test logs: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-2177/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 2 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12688802 - PreCommit-HIVE-TRUNK-Build

  In select statement after * any random characters are allowed in hive but in 
 RDBMS its not allowed
 ---

 Key: HIVE-8155
 URL: https://issues.apache.org/jira/browse/HIVE-8155
 Project: Hive
  Issue Type: Improvement
Reporter: Ferdinand Xu
Assignee: Dong Chen
Priority: Critical
 Attachments: HIVE-8155.1.patch, HIVE-8155.patch


 In select statement after * any random characters are allowed in hive but in 
 RDBMS its not allowed. 
 Steps:
 In the below query abcdef is random characters.
 In RDBMS(oracle): 
 select *abcdef from mytable;
 Output: 
 ERROR prepare() failed with: ORA-00923: FROM keyword not found where expected
 In Hive:
 select *abcdef from mytable;
 Output: 
 Query worked fine and display all the records of mytable.



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

[jira] [Commented] (HIVE-8155) In select statement after * any random characters are allowed in hive but in RDBMS its not allowed

2014-12-23 Thread Ashutosh Chauhan (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-8155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14257409#comment-14257409
 ] 

Ashutosh Chauhan commented on HIVE-8155:


LGTM +1

  In select statement after * any random characters are allowed in hive but in 
 RDBMS its not allowed
 ---

 Key: HIVE-8155
 URL: https://issues.apache.org/jira/browse/HIVE-8155
 Project: Hive
  Issue Type: Improvement
Reporter: Ferdinand Xu
Assignee: Dong Chen
Priority: Critical
 Attachments: HIVE-8155.1.patch, HIVE-8155.patch


 In select statement after * any random characters are allowed in hive but in 
 RDBMS its not allowed. 
 Steps:
 In the below query abcdef is random characters.
 In RDBMS(oracle): 
 select *abcdef from mytable;
 Output: 
 ERROR prepare() failed with: ORA-00923: FROM keyword not found where expected
 In Hive:
 select *abcdef from mytable;
 Output: 
 Query worked fine and display all the records of mytable.



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

[jira] [Commented] (HIVE-8155) In select statement after * any random characters are allowed in hive but in RDBMS its not allowed

2014-12-22 Thread Sergey Shelukhin (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-8155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14256258#comment-14256258
 ] 

Sergey Shelukhin commented on HIVE-8155:


What would the original result of the query be? There's code in Hive where * is 
resolved that appears to resolve column names based on regex. I never tried it, 
but it seems that the original intent might have been to be able to 
pattern-match columns, E.g. select *_name from employee to select first and 
last name, or something. It's rather esoteric, but would be nice to check

  In select statement after * any random characters are allowed in hive but in 
 RDBMS its not allowed
 ---

 Key: HIVE-8155
 URL: https://issues.apache.org/jira/browse/HIVE-8155
 Project: Hive
  Issue Type: Improvement
Reporter: Ferdinand Xu
Assignee: Dong Chen
Priority: Critical
 Attachments: HIVE-8155.patch


 In select statement after * any random characters are allowed in hive but in 
 RDBMS its not allowed. 
 Steps:
 In the below query abcdef is random characters.
 In RDBMS(oracle): 
 select *abcdef from mytable;
 Output: 
 ERROR prepare() failed with: ORA-00923: FROM keyword not found where expected
 In Hive:
 select *abcdef from mytable;
 Output: 
 Query worked fine and display all the records of mytable.



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

[jira] [Commented] (HIVE-8155) In select statement after * any random characters are allowed in hive but in RDBMS its not allowed

2014-12-22 Thread Dong Chen (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-8155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14256540#comment-14256540
 ] 

Dong Chen commented on HIVE-8155:
-

Thank you for comments! [~sershe]
bq. What would the original result of the query be?
return all the columns, no matter the string following * is column name or 
random.

bq. E.g. select *_name from employee to select first and last name, or 
something. It's rather esoteric, but would be nice to check
I checked a table u_data with 4 columns. Two of columns are userid and movieid.
{{select *id from u_data}} still returns all the 4 columns.

  In select statement after * any random characters are allowed in hive but in 
 RDBMS its not allowed
 ---

 Key: HIVE-8155
 URL: https://issues.apache.org/jira/browse/HIVE-8155
 Project: Hive
  Issue Type: Improvement
Reporter: Ferdinand Xu
Assignee: Dong Chen
Priority: Critical
 Attachments: HIVE-8155.patch


 In select statement after * any random characters are allowed in hive but in 
 RDBMS its not allowed. 
 Steps:
 In the below query abcdef is random characters.
 In RDBMS(oracle): 
 select *abcdef from mytable;
 Output: 
 ERROR prepare() failed with: ORA-00923: FROM keyword not found where expected
 In Hive:
 select *abcdef from mytable;
 Output: 
 Query worked fine and display all the records of mytable.



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

[jira] [Commented] (HIVE-8155) In select statement after * any random characters are allowed in hive but in RDBMS its not allowed

2014-12-22 Thread Hive QA (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-8155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14256553#comment-14256553
 ] 

Hive QA commented on HIVE-8155:
---



{color:red}Overall{color}: -1 at least one tests failed

Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12688618/HIVE-8155.patch

{color:red}ERROR:{color} -1 due to 3 failed/errored test(s), 6720 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_lvj_mapjoin
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_optimize_nullscan
org.apache.hadoop.hive.ql.parse.TestParseNegative.testParseNegative_wrong_distinct2
{noformat}

Test results: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2164/testReport
Console output: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2164/console
Test logs: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-2164/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 3 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12688618 - PreCommit-HIVE-TRUNK-Build

  In select statement after * any random characters are allowed in hive but in 
 RDBMS its not allowed
 ---

 Key: HIVE-8155
 URL: https://issues.apache.org/jira/browse/HIVE-8155
 Project: Hive
  Issue Type: Improvement
Reporter: Ferdinand Xu
Assignee: Dong Chen
Priority: Critical
 Attachments: HIVE-8155.patch


 In select statement after * any random characters are allowed in hive but in 
 RDBMS its not allowed. 
 Steps:
 In the below query abcdef is random characters.
 In RDBMS(oracle): 
 select *abcdef from mytable;
 Output: 
 ERROR prepare() failed with: ORA-00923: FROM keyword not found where expected
 In Hive:
 select *abcdef from mytable;
 Output: 
 Query worked fine and display all the records of mytable.



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

[jira] [Commented] (HIVE-8155) In select statement after * any random characters are allowed in hive but in RDBMS its not allowed

2014-11-21 Thread Ashutosh Chauhan (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-8155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14221034#comment-14221034
 ] 

Ashutosh Chauhan commented on HIVE-8155:


[~sershe] Is this related to RR issues you are looking at ?

  In select statement after * any random characters are allowed in hive but in 
 RDBMS its not allowed
 ---

 Key: HIVE-8155
 URL: https://issues.apache.org/jira/browse/HIVE-8155
 Project: Hive
  Issue Type: Improvement
Reporter: Ferdinand Xu
Priority: Critical

 In select statement after * any random characters are allowed in hive but in 
 RDBMS its not allowed. 
 Steps:
 In the below query abcdef is random characters.
 In RDBMS(oracle): 
 select *abcdef from mytable;
 Output: 
 ERROR prepare() failed with: ORA-00923: FROM keyword not found where expected
 In Hive:
 select *abcdef from mytable;
 Output: 
 Query worked fine and display all the records of mytable.



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

[jira] [Commented] (HIVE-8155) In select statement after * any random characters are allowed in hive but in RDBMS its not allowed

2014-11-21 Thread Sergey Shelukhin (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-8155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14221143#comment-14221143
 ] 

Sergey Shelukhin commented on HIVE-8155:


No. It might be in the same code though

  In select statement after * any random characters are allowed in hive but in 
 RDBMS its not allowed
 ---

 Key: HIVE-8155
 URL: https://issues.apache.org/jira/browse/HIVE-8155
 Project: Hive
  Issue Type: Improvement
Reporter: Ferdinand Xu
Priority: Critical

 In select statement after * any random characters are allowed in hive but in 
 RDBMS its not allowed. 
 Steps:
 In the below query abcdef is random characters.
 In RDBMS(oracle): 
 select *abcdef from mytable;
 Output: 
 ERROR prepare() failed with: ORA-00923: FROM keyword not found where expected
 In Hive:
 select *abcdef from mytable;
 Output: 
 Query worked fine and display all the records of mytable.



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