Miki Tanaka created HIVE-3093:
---------------------------------
Summary: TABLESAMPLE doesnt work with LEFT OUTER JOIN
Key: HIVE-3093
URL: https://issues.apache.org/jira/browse/HIVE-3093
Project: Hive
Issue Type: Bug
Reporter: Miki Tanaka
SELECT * FROM (table1) a LEFT OUTER JOIN (table2) b ON (a.j1 = b.j2)
TABLESAMPLE (BUCKET 1 OUT OF 512 ON a.col1) GROUP BY a.col1, b.col1
Got the error below.
Error in QueryHive::query_via_thrift after 1 retries. error=Query returned
non-zero code: 11, cause: FAILED: Parse Error: line 1:418 mismatched input
'tablesample' expecting EOF near ')'
Also tried the below for enfancing sub query 'x'.
SELECT * FROM (SELECT * FROM (table1) a LEFT OUTER JOIN (table2) b ON (a.j1 =
b.j2) GROUP BY a.col1, b.col1) x TABLESAMPLE (BUCKET 1 OUT OF 512 ON a.col1)
Faild as below...
Error in QueryHive::query_via_thrift after 1 retries. error=Query returned
non-zero code: 11, cause: FAILED: Parse Error: line 1:100 cannot recognize
input near '(' 'select' in subquery source
Anyone help for it?
I dont know how to open any attachment here, would be appriciated it if you
fill in your comments directly here...
--
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
