[
https://issues.apache.org/jira/browse/HIVE-8155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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)
