You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Miki Tanaka (JIRA)" <ji...@apache.org> on 2012/06/06 13:40:22 UTC
[jira] [Created] (HIVE-3093) TABLESAMPLE doesnt work with LEFT
OUTER JOIN
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
[jira] [Commented] (HIVE-3093) TABLESAMPLE doesnt work with LEFT
OUTER JOIN
Posted by "Miki Tanaka (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3093?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13290093#comment-13290093 ]
Miki Tanaka commented on HIVE-3093:
-----------------------------------
Thanks Navis.
Tried as your advice, but...
Error in QueryHive::query_via_thrift after 1 retries. error=Query returned non-zero code: 11, cause: FAILED: Parse Error: line 1:282 mismatched input 'tablesample' expecting Identifier near ')' in subquery source
Do you have another ideas?
> 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
[jira] [Resolved] (HIVE-3093) TABLESAMPLE doesnt work with LEFT
OUTER JOIN
Posted by "Miki Tanaka (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3093?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Miki Tanaka resolved HIVE-3093.
-------------------------------
Resolution: Fixed
> 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
[jira] [Resolved] (HIVE-3093) TABLESAMPLE doesnt work with LEFT
OUTER JOIN
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3093?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach resolved HIVE-3093.
----------------------------------
Resolution: Invalid
> 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
[jira] [Reopened] (HIVE-3093) TABLESAMPLE doesnt work with LEFT
OUTER JOIN
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3093?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach reopened HIVE-3093:
----------------------------------
> 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
[jira] [Commented] (HIVE-3093) TABLESAMPLE doesnt work with LEFT
OUTER JOIN
Posted by "Navis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3093?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13290089#comment-13290089 ]
Navis commented on HIVE-3093:
-----------------------------
You mean something like..
SELECT * FROM (SELECT * FROM src TABLESAMPLE (BUCKET 1 OUT OF 512 ON key) a LEFT OUTER JOIN src b ON (a.key = b.key) GROUP BY a.key, b.key) x;
> 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