You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "ASK (JIRA)" <ji...@apache.org> on 2012/06/15 05:09:42 UTC
[jira] [Created] (HIVE-3141) Bug in SELECT query
ASK created HIVE-3141:
-------------------------
Summary: Bug in SELECT query
Key: HIVE-3141
URL: https://issues.apache.org/jira/browse/HIVE-3141
Project: Hive
Issue Type: Bug
Components: CLI
Environment:
OS: Ubuntu
Hive version: hive-0.7.1-cdh3u2
Hadoop : hadoop-0.20.2
Reporter: ASK
When i use ' select *(followed by any alphan-numeric character) frm table '. the query is working.
eg. select *fdkfj3434 from stocks.
It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-3141) Bug in SELECT query
Posted by "rohithsharma (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
rohithsharma updated HIVE-3141:
-------------------------------
Component/s: (was: CLI)
Tests
> Bug in SELECT query
> -------------------
>
> Key: HIVE-3141
> URL: https://issues.apache.org/jira/browse/HIVE-3141
> Project: Hive
> Issue Type: Bug
> Components: Tests
> Environment: OS: Ubuntu
> Hive version: hive-0.7.1-cdh3u2
> Hadoop : hadoop-0.20.2
> Reporter: ASK
>
> When i use ' select *(followed by any alphan-numeric character) frm table , query is throwing some issues. It display the result for select *
> It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-3141) Bug in SELECT query
Posted by "rohithsharma (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
rohithsharma updated HIVE-3141:
-------------------------------
Component/s: (was: Tests)
CLI
> Bug in SELECT query
> -------------------
>
> Key: HIVE-3141
> URL: https://issues.apache.org/jira/browse/HIVE-3141
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Environment: OS: Ubuntu
> Hive version: hive-0.7.1-cdh3u2
> Hadoop : hadoop-0.20.2
> Reporter: ASK
>
> When i use ' select *(followed by any alphan-numeric character) frm table , query is throwing some issues. It display the result for select *
> It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-3141) Bug in SELECT query
Posted by "Ajesh Kumar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13458393#comment-13458393 ]
Ajesh Kumar commented on HIVE-3141:
-----------------------------------
Hi Carl
when we execute 'select' query , it is not invoking SemanticAnalyzer.class. Let me know if I can go ahead with modifying parse() method in ParseDriver.java.
> Bug in SELECT query
> -------------------
>
> Key: HIVE-3141
> URL: https://issues.apache.org/jira/browse/HIVE-3141
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Affects Versions: 0.9.0
> Environment: OS: Ubuntu
> Hive version: hive-0.7.1-cdh3u2
> Hadoop : hadoop-0.20.2
> Reporter: ASK
> Assignee: Ajesh Kumar
> Priority: Minor
> Labels: patch
> Attachments: HIVE-3141.2.patch.txt, Hive_bug_3141_resolution.pdf, select_syntax.q, select_syntax.q.out
>
>
> When i try to execute select *(followed by any alphanumeric character) from table , query is throwing some issues. It display the result for select *
> It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-3141) Bug in SELECT query
Posted by "Ajesh Kumar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ajesh Kumar updated HIVE-3141:
------------------------------
Status: Patch Available (was: Open)
Adding q file and q.out file for negative test
> Bug in SELECT query
> -------------------
>
> Key: HIVE-3141
> URL: https://issues.apache.org/jira/browse/HIVE-3141
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Affects Versions: 0.9.0
> Environment: OS: Ubuntu
> Hive version: hive-0.7.1-cdh3u2
> Hadoop : hadoop-0.20.2
> Reporter: ASK
> Priority: Minor
> Labels: patch
> Attachments: HIVE-3141.1.patch.txt, Hive_bug_3141_resolution.pdf, select_syntax.q, select_syntax.q.out
>
>
> When i try to execute select *(followed by any alphanumeric character) from table , query is throwing some issues. It display the result for select *
> It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-3141) Bug in SELECT query
Posted by "Ajesh Kumar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13448582#comment-13448582 ]
Ajesh Kumar commented on HIVE-3141:
-----------------------------------
Thanks Carl
I have added review request in reviews.apache.org.
Please find the link for the same https://reviews.apache.org/r/6919/
> Bug in SELECT query
> -------------------
>
> Key: HIVE-3141
> URL: https://issues.apache.org/jira/browse/HIVE-3141
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Affects Versions: 0.9.0
> Environment: OS: Ubuntu
> Hive version: hive-0.7.1-cdh3u2
> Hadoop : hadoop-0.20.2
> Reporter: ASK
> Priority: Minor
> Labels: patch
> Attachments: HIVE-3141.1.patch.txt, HIVE-3141.2.patch.txt, Hive_bug_3141_resolution.pdf, select_syntax.q, select_syntax.q.out
>
>
> When i try to execute select *(followed by any alphanumeric character) from table , query is throwing some issues. It display the result for select *
> It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-3141) Bug in SELECT query
Posted by "Ajesh Kumar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13451927#comment-13451927 ]
Ajesh Kumar commented on HIVE-3141:
-----------------------------------
Parsing is done in org.apache.hadoop.hive.ql.parse.HiveParser.java. But source code for this file is not available in hadoop distribution.
Another option is to modify parse() method in ParseDriver.java to add extra verification for the syntax .All the services like cli,hiveserver uses this method for parsing. Let me know your comments.
> Bug in SELECT query
> -------------------
>
> Key: HIVE-3141
> URL: https://issues.apache.org/jira/browse/HIVE-3141
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Affects Versions: 0.9.0
> Environment: OS: Ubuntu
> Hive version: hive-0.7.1-cdh3u2
> Hadoop : hadoop-0.20.2
> Reporter: ASK
> Priority: Minor
> Labels: patch
> Attachments: HIVE-3141.2.patch.txt, Hive_bug_3141_resolution.pdf, select_syntax.q, select_syntax.q.out
>
>
> When i try to execute select *(followed by any alphanumeric character) from table , query is throwing some issues. It display the result for select *
> It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-3141) Bug in SELECT query
Posted by "Navis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13393699#comment-13393699 ]
Navis commented on HIVE-3141:
-----------------------------
It accepts regex expressions..
select `.*(your-alphanumerics)` from table;
> Bug in SELECT query
> -------------------
>
> Key: HIVE-3141
> URL: https://issues.apache.org/jira/browse/HIVE-3141
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Environment: OS: Ubuntu
> Hive version: hive-0.7.1-cdh3u2
> Hadoop : hadoop-0.20.2
> Reporter: ASK
> Priority: Minor
>
> When i try to execute select *(followed by any alphanumeric character) from table , query is throwing some issues. It display the result for select *
> It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-3141) Bug in SELECT query
Posted by "Ajesh Kumar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ajesh Kumar updated HIVE-3141:
------------------------------
Attachment: select_syntax.q.out
select_syntax.q
Adding q file and q.out file for negative test.
> Bug in SELECT query
> -------------------
>
> Key: HIVE-3141
> URL: https://issues.apache.org/jira/browse/HIVE-3141
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Affects Versions: 0.9.0
> Environment: OS: Ubuntu
> Hive version: hive-0.7.1-cdh3u2
> Hadoop : hadoop-0.20.2
> Reporter: ASK
> Priority: Minor
> Labels: patch
> Attachments: HIVE-3141.1.patch.txt, Hive_bug_3141_resolution.pdf, select_syntax.q, select_syntax.q.out
>
>
> When i try to execute select *(followed by any alphanumeric character) from table , query is throwing some issues. It display the result for select *
> It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-3141) Bug in SELECT query
Posted by "Ajesh Kumar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ajesh Kumar updated HIVE-3141:
------------------------------
Attachment: HIVE-3141.1.patch.txt
Made change in CliDriver.java to make a check on the syntax of select statement.Please do a code review.
The attached screen shot "Hive_bug_3141_resolution.pdf" shows how the select query works after the patch done in my local.
> Bug in SELECT query
> -------------------
>
> Key: HIVE-3141
> URL: https://issues.apache.org/jira/browse/HIVE-3141
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Environment: OS: Ubuntu
> Hive version: hive-0.7.1-cdh3u2
> Hadoop : hadoop-0.20.2
> Reporter: ASK
> Priority: Minor
> Attachments: HIVE-3141.1.patch.txt, Hive_bug_3141_resolution.pdf
>
>
> When i try to execute select *(followed by any alphanumeric character) from table , query is throwing some issues. It display the result for select *
> It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-3141) Bug in SELECT query
Posted by "ASK (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASK updated HIVE-3141:
----------------------
Description:
When i try to execute select *(followed by any alphanumeric character) from table , query is throwing some issues. It display the result for select *
It doesnot happen when only numbers follow the *
was:
When i use ' select *(followed by any alphan-numeric character) frm table , query is throwing some issues. It display the result for select *
It doesnot happen when only numbers follow the *
Priority: Minor (was: Major)
> Bug in SELECT query
> -------------------
>
> Key: HIVE-3141
> URL: https://issues.apache.org/jira/browse/HIVE-3141
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Environment: OS: Ubuntu
> Hive version: hive-0.7.1-cdh3u2
> Hadoop : hadoop-0.20.2
> Reporter: ASK
> Priority: Minor
>
> When i try to execute select *(followed by any alphanumeric character) from table , query is throwing some issues. It display the result for select *
> It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-3141) Bug in SELECT query
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13430932#comment-13430932 ]
Namit Jain commented on HIVE-3141:
----------------------------------
@Ajesh, can you add some tests in ql/src/test/queries/clientnegative
Look at the various .q files present there.
More details at
https://cwiki.apache.org/Hive/developerguide.html#DeveloperGuide-Unittestsanddebugging
> Bug in SELECT query
> -------------------
>
> Key: HIVE-3141
> URL: https://issues.apache.org/jira/browse/HIVE-3141
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Affects Versions: 0.9.0
> Environment: OS: Ubuntu
> Hive version: hive-0.7.1-cdh3u2
> Hadoop : hadoop-0.20.2
> Reporter: ASK
> Priority: Minor
> Labels: patch
> Attachments: HIVE-3141.1.patch.txt, Hive_bug_3141_resolution.pdf
>
>
> When i try to execute select *(followed by any alphanumeric character) from table , query is throwing some issues. It display the result for select *
> It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-3141) Bug in SELECT query
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13452275#comment-13452275 ]
Carl Steinbach commented on HIVE-3141:
--------------------------------------
HiveParser.java is autogenerated by ANTLR using the Hive grammar file located here:
ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g
bq. Another option is to modify parse() method in ParseDriver.java to add extra verification for the syntax .All the services like cli,hiveserver uses this method for parsing. Let me know your comments.
The right place for this check is probably somewhere in the SemanticAnalyzer class. Please take a look at this, and in particular pay attention to the places where SemanticExceptions are thrown.
> Bug in SELECT query
> -------------------
>
> Key: HIVE-3141
> URL: https://issues.apache.org/jira/browse/HIVE-3141
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Affects Versions: 0.9.0
> Environment: OS: Ubuntu
> Hive version: hive-0.7.1-cdh3u2
> Hadoop : hadoop-0.20.2
> Reporter: ASK
> Priority: Minor
> Labels: patch
> Attachments: HIVE-3141.2.patch.txt, Hive_bug_3141_resolution.pdf, select_syntax.q, select_syntax.q.out
>
>
> When i try to execute select *(followed by any alphanumeric character) from table , query is throwing some issues. It display the result for select *
> It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-3141) Bug in SELECT query
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13449167#comment-13449167 ]
Carl Steinbach commented on HIVE-3141:
--------------------------------------
Syntax checks like this don't belong in CliDriver because other clients (e.g. Thrift) bypass this logic. We should either modify the grammar to find problems like this, or else do the same check in the SemanticAnalyzer.
> Bug in SELECT query
> -------------------
>
> Key: HIVE-3141
> URL: https://issues.apache.org/jira/browse/HIVE-3141
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Affects Versions: 0.9.0
> Environment: OS: Ubuntu
> Hive version: hive-0.7.1-cdh3u2
> Hadoop : hadoop-0.20.2
> Reporter: ASK
> Priority: Minor
> Labels: patch
> Attachments: HIVE-3141.2.patch.txt, Hive_bug_3141_resolution.pdf, select_syntax.q, select_syntax.q.out
>
>
> When i try to execute select *(followed by any alphanumeric character) from table , query is throwing some issues. It display the result for select *
> It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-3141) Bug in SELECT query
Posted by "ASK (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASK updated HIVE-3141:
----------------------
Description:
When i use ' select *(followed by any alphan-numeric character) frm table , query is throwing some issues. It display the result for select *
It doesnot happen when only numbers follow the *
was:
When i use ' select *(followed by any alphan-numeric character) frm table '. the query is working.
eg. select *fdkfj3434 from stocks.
It doesnot happen when only numbers follow the *
Environment:
OS: Ubuntu
Hive version: hive-0.7.1-cdh3u2
Hadoop : hadoop-0.20.2
was:
OS: Ubuntu
Hive version: hive-0.7.1-cdh3u2
Hadoop : hadoop-0.20.2
> Bug in SELECT query
> -------------------
>
> Key: HIVE-3141
> URL: https://issues.apache.org/jira/browse/HIVE-3141
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Environment: OS: Ubuntu
> Hive version: hive-0.7.1-cdh3u2
> Hadoop : hadoop-0.20.2
> Reporter: ASK
>
> When i use ' select *(followed by any alphan-numeric character) frm table , query is throwing some issues. It display the result for select *
> It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-3141) Bug in SELECT query
Posted by "Ajesh Kumar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ajesh Kumar updated HIVE-3141:
------------------------------
Attachment: (was: HIVE-3141.1.patch.txt)
> Bug in SELECT query
> -------------------
>
> Key: HIVE-3141
> URL: https://issues.apache.org/jira/browse/HIVE-3141
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Affects Versions: 0.9.0
> Environment: OS: Ubuntu
> Hive version: hive-0.7.1-cdh3u2
> Hadoop : hadoop-0.20.2
> Reporter: ASK
> Priority: Minor
> Labels: patch
> Attachments: HIVE-3141.2.patch.txt, Hive_bug_3141_resolution.pdf, select_syntax.q, select_syntax.q.out
>
>
> When i try to execute select *(followed by any alphanumeric character) from table , query is throwing some issues. It display the result for select *
> It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-3141) Bug in SELECT query
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13447488#comment-13447488 ]
Carl Steinbach commented on HIVE-3141:
--------------------------------------
@Ajesh: Can you please try using the reviews.apache.org site instead? This site does not require you to install any client-side components. Thanks.
> Bug in SELECT query
> -------------------
>
> Key: HIVE-3141
> URL: https://issues.apache.org/jira/browse/HIVE-3141
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Affects Versions: 0.9.0
> Environment: OS: Ubuntu
> Hive version: hive-0.7.1-cdh3u2
> Hadoop : hadoop-0.20.2
> Reporter: ASK
> Priority: Minor
> Labels: patch
> Attachments: HIVE-3141.1.patch.txt, HIVE-3141.2.patch.txt, Hive_bug_3141_resolution.pdf, select_syntax.q, select_syntax.q.out
>
>
> When i try to execute select *(followed by any alphanumeric character) from table , query is throwing some issues. It display the result for select *
> It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-3141) Bug in SELECT query
Posted by "Ajesh Kumar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ajesh Kumar updated HIVE-3141:
------------------------------
Attachment: HIVE-3141.2.patch.txt
Adding all changes in a single patch file. HIVE-3141.2.patch.txt
> Bug in SELECT query
> -------------------
>
> Key: HIVE-3141
> URL: https://issues.apache.org/jira/browse/HIVE-3141
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Affects Versions: 0.9.0
> Environment: OS: Ubuntu
> Hive version: hive-0.7.1-cdh3u2
> Hadoop : hadoop-0.20.2
> Reporter: ASK
> Priority: Minor
> Labels: patch
> Attachments: HIVE-3141.1.patch.txt, HIVE-3141.2.patch.txt, Hive_bug_3141_resolution.pdf, select_syntax.q, select_syntax.q.out
>
>
> When i try to execute select *(followed by any alphanumeric character) from table , query is throwing some issues. It display the result for select *
> It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-3141) Bug in SELECT query
Posted by "Ajesh Kumar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13430898#comment-13430898 ]
Ajesh Kumar commented on HIVE-3141:
-----------------------------------
Hi Namit,
Both positive and negative tests are included in the attachment "Hive_bug_3141_resolution.pdf". Please let me know if I am missing any specific scenario?
thanks
> Bug in SELECT query
> -------------------
>
> Key: HIVE-3141
> URL: https://issues.apache.org/jira/browse/HIVE-3141
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Affects Versions: 0.9.0
> Environment: OS: Ubuntu
> Hive version: hive-0.7.1-cdh3u2
> Hadoop : hadoop-0.20.2
> Reporter: ASK
> Priority: Minor
> Labels: patch
> Attachments: HIVE-3141.1.patch.txt, Hive_bug_3141_resolution.pdf
>
>
> When i try to execute select *(followed by any alphanumeric character) from table , query is throwing some issues. It display the result for select *
> It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-3141) Bug in SELECT query
Posted by "Ajesh Kumar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ajesh Kumar updated HIVE-3141:
------------------------------
Status: Patch Available (was: Open)
Hi Namit,
I have added all the changes in a single patch file, HIVE-3141.2.patch.txt.
Please do a review. Because of some software installation limitations, I am not able to install the required software for using Phabricator.So I am not able to create a review for the patch.
> Bug in SELECT query
> -------------------
>
> Key: HIVE-3141
> URL: https://issues.apache.org/jira/browse/HIVE-3141
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Affects Versions: 0.9.0
> Environment: OS: Ubuntu
> Hive version: hive-0.7.1-cdh3u2
> Hadoop : hadoop-0.20.2
> Reporter: ASK
> Priority: Minor
> Labels: patch
> Attachments: HIVE-3141.1.patch.txt, HIVE-3141.2.patch.txt, Hive_bug_3141_resolution.pdf, select_syntax.q, select_syntax.q.out
>
>
> When i try to execute select *(followed by any alphanumeric character) from table , query is throwing some issues. It display the result for select *
> It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-3141) Bug in SELECT query
Posted by "ASK (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASK updated HIVE-3141:
----------------------
Status: Patch Available (was: Open)
> Bug in SELECT query
> -------------------
>
> Key: HIVE-3141
> URL: https://issues.apache.org/jira/browse/HIVE-3141
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Environment: OS: Ubuntu
> Hive version: hive-0.7.1-cdh3u2
> Hadoop : hadoop-0.20.2
> Reporter: ASK
>
> When i use ' select *(followed by any alphan-numeric character) frm table '. the query is working.
> eg. select *fdkfj3434 from stocks.
> It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-3141) Bug in SELECT query
Posted by "ASK (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASK updated HIVE-3141:
----------------------
Status: Open (was: Patch Available)
> Bug in SELECT query
> -------------------
>
> Key: HIVE-3141
> URL: https://issues.apache.org/jira/browse/HIVE-3141
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Environment: OS: Ubuntu
> Hive version: hive-0.7.1-cdh3u2
> Hadoop : hadoop-0.20.2
> Reporter: ASK
>
> When i use ' select *(followed by any alphan-numeric character) frm table '. the query is working.
> eg. select *fdkfj3434 from stocks.
> It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-3141) Bug in SELECT query
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-3141:
-----------------------------
Status: Open (was: Patch Available)
> Bug in SELECT query
> -------------------
>
> Key: HIVE-3141
> URL: https://issues.apache.org/jira/browse/HIVE-3141
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Affects Versions: 0.9.0
> Environment: OS: Ubuntu
> Hive version: hive-0.7.1-cdh3u2
> Hadoop : hadoop-0.20.2
> Reporter: ASK
> Priority: Minor
> Labels: patch
> Attachments: HIVE-3141.1.patch.txt, Hive_bug_3141_resolution.pdf
>
>
> When i try to execute select *(followed by any alphanumeric character) from table , query is throwing some issues. It display the result for select *
> It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-3141) Bug in SELECT query
Posted by "Ajesh Kumar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ajesh Kumar updated HIVE-3141:
------------------------------
Attachment: Hive_bug_3141_resolution.pdf
we can provide extra verification for the syntax of select statement to address the issue raised. This would provide an appropriate error message to the user if the syntax is wrong. I have made a change in my local source code which accomplishes this proposed solution . I have attached a screen shot "Hive_bug_3141_resolution.pdf" for reference.
> Bug in SELECT query
> -------------------
>
> Key: HIVE-3141
> URL: https://issues.apache.org/jira/browse/HIVE-3141
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Environment: OS: Ubuntu
> Hive version: hive-0.7.1-cdh3u2
> Hadoop : hadoop-0.20.2
> Reporter: ASK
> Priority: Minor
> Attachments: Hive_bug_3141_resolution.pdf
>
>
> When i try to execute select *(followed by any alphanumeric character) from table , query is throwing some issues. It display the result for select *
> It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-3141) Bug in SELECT query
Posted by "Ajesh Kumar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13453736#comment-13453736 ]
Ajesh Kumar commented on HIVE-3141:
-----------------------------------
Hi Carl,
when we execute 'select' query , it is not invoking SemanticAnalyzer.class.
Let me know if I am missing something in my analysis.
> Bug in SELECT query
> -------------------
>
> Key: HIVE-3141
> URL: https://issues.apache.org/jira/browse/HIVE-3141
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Affects Versions: 0.9.0
> Environment: OS: Ubuntu
> Hive version: hive-0.7.1-cdh3u2
> Hadoop : hadoop-0.20.2
> Reporter: ASK
> Priority: Minor
> Labels: patch
> Attachments: HIVE-3141.2.patch.txt, Hive_bug_3141_resolution.pdf, select_syntax.q, select_syntax.q.out
>
>
> When i try to execute select *(followed by any alphanumeric character) from table , query is throwing some issues. It display the result for select *
> It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-3141) Bug in SELECT query
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-3141:
---------------------------------
Status: Open (was: Patch Available)
> Bug in SELECT query
> -------------------
>
> Key: HIVE-3141
> URL: https://issues.apache.org/jira/browse/HIVE-3141
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Affects Versions: 0.9.0
> Environment: OS: Ubuntu
> Hive version: hive-0.7.1-cdh3u2
> Hadoop : hadoop-0.20.2
> Reporter: ASK
> Priority: Minor
> Labels: patch
> Attachments: HIVE-3141.2.patch.txt, Hive_bug_3141_resolution.pdf, select_syntax.q, select_syntax.q.out
>
>
> When i try to execute select *(followed by any alphanumeric character) from table , query is throwing some issues. It display the result for select *
> It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Assigned] (HIVE-3141) Bug in SELECT query
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain reassigned HIVE-3141:
--------------------------------
Assignee: Ajesh Kumar
> Bug in SELECT query
> -------------------
>
> Key: HIVE-3141
> URL: https://issues.apache.org/jira/browse/HIVE-3141
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Affects Versions: 0.9.0
> Environment: OS: Ubuntu
> Hive version: hive-0.7.1-cdh3u2
> Hadoop : hadoop-0.20.2
> Reporter: ASK
> Assignee: Ajesh Kumar
> Priority: Minor
> Labels: patch
> Attachments: HIVE-3141.2.patch.txt, Hive_bug_3141_resolution.pdf, select_syntax.q, select_syntax.q.out
>
>
> When i try to execute select *(followed by any alphanumeric character) from table , query is throwing some issues. It display the result for select *
> It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-3141) Bug in SELECT query
Posted by "Ajesh Kumar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ajesh Kumar updated HIVE-3141:
------------------------------
Labels: patch (was: )
Affects Version/s: 0.9.0
Status: Patch Available (was: Open)
Made change in CliDriver.java to make an extra check on the syntax of select statement.
The attached screen shot "Hive_bug_3141_resolution.pdf" shows how the select query works after the patch done in my local
> Bug in SELECT query
> -------------------
>
> Key: HIVE-3141
> URL: https://issues.apache.org/jira/browse/HIVE-3141
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Affects Versions: 0.9.0
> Environment: OS: Ubuntu
> Hive version: hive-0.7.1-cdh3u2
> Hadoop : hadoop-0.20.2
> Reporter: ASK
> Priority: Minor
> Labels: patch
> Attachments: HIVE-3141.1.patch.txt, Hive_bug_3141_resolution.pdf
>
>
> When i try to execute select *(followed by any alphanumeric character) from table , query is throwing some issues. It display the result for select *
> It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-3141) Bug in SELECT query
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13430885#comment-13430885 ]
Namit Jain commented on HIVE-3141:
----------------------------------
Can you add negative test for the scenarios you mentioned ?
> Bug in SELECT query
> -------------------
>
> Key: HIVE-3141
> URL: https://issues.apache.org/jira/browse/HIVE-3141
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Affects Versions: 0.9.0
> Environment: OS: Ubuntu
> Hive version: hive-0.7.1-cdh3u2
> Hadoop : hadoop-0.20.2
> Reporter: ASK
> Priority: Minor
> Labels: patch
> Attachments: HIVE-3141.1.patch.txt, Hive_bug_3141_resolution.pdf
>
>
> When i try to execute select *(followed by any alphanumeric character) from table , query is throwing some issues. It display the result for select *
> It doesnot happen when only numbers follow the *
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira