[
https://issues.apache.org/jira/browse/HIVE-9923?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14498288#comment-14498288
]
Yongzhi Chen commented on HIVE-9923:
------------------------------------
Hive support simple select without from statement (when there is a UDF). When
select in an insert statement, hive need the from clause. The new patch only
check from clause null or not in the insert statement.
> No clear message when "from" is missing
> ---------------------------------------
>
> Key: HIVE-9923
> URL: https://issues.apache.org/jira/browse/HIVE-9923
> Project: Hive
> Issue Type: Bug
> Affects Versions: 1.0.0
> Reporter: Jeff Zhang
> Assignee: Yongzhi Chen
> Attachments: HIVE-9923.1.patch
>
>
> For the following sql, "from" is missing but it throw NPE which is not clear
> for user.
> {code}
> hive> insert overwrite directory '/tmp/hive-3' select sb1.name, sb2.age
> student_bucketed sb1 join student_bucketed sb2 on sb1.name=sb2.name;
> FAILED: NullPointerException null
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
