You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "John Sichi (JIRA)" <ji...@apache.org> on 2010/12/20 23:57:01 UTC
[jira] Created: (HIVE-1857) mixed case tablename on lefthand side
of LATERAL VIEW results in query failing with confusing error message
mixed case tablename on lefthand side of LATERAL VIEW results in query failing with confusing error message
-----------------------------------------------------------------------------------------------------------
Key: HIVE-1857
URL: https://issues.apache.org/jira/browse/HIVE-1857
Project: Hive
Issue Type: Bug
Components: Query Processor
Affects Versions: 0.6.0
Reporter: John Sichi
Assignee: John Sichi
Fix For: 0.7.0
Attachments: HIVE-1857.1.patch
For the modified query below in lateral_view.q, the exception "org.apache.hadoop.hive.ql.parse.SemanticException: line 3:7 Invalid Table Alias or Column Reference myCol" is thrown. The query should succeed.
SELECT myCol from tmp_PYANG_lv LATERAL VIEW explode(array(1,2,3)) myTab as myCol limit 3;
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1857) mixed case tablename on lefthand side
of LATERAL VIEW results in query failing with confusing error message
Posted by "John Sichi (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1857?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
John Sichi updated HIVE-1857:
-----------------------------
Attachment: HIVE-1857.1.patch
> mixed case tablename on lefthand side of LATERAL VIEW results in query failing with confusing error message
> -----------------------------------------------------------------------------------------------------------
>
> Key: HIVE-1857
> URL: https://issues.apache.org/jira/browse/HIVE-1857
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Affects Versions: 0.6.0
> Reporter: John Sichi
> Assignee: John Sichi
> Fix For: 0.7.0
>
> Attachments: HIVE-1857.1.patch
>
>
> For the modified query below in lateral_view.q, the exception "org.apache.hadoop.hive.ql.parse.SemanticException: line 3:7 Invalid Table Alias or Column Reference myCol" is thrown. The query should succeed.
> SELECT myCol from tmp_PYANG_lv LATERAL VIEW explode(array(1,2,3)) myTab as myCol limit 3;
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-1857) mixed case tablename on lefthand side
of LATERAL VIEW results in query failing with confusing error message
Posted by "Paul Yang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1857?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12973406#action_12973406 ]
Paul Yang commented on HIVE-1857:
---------------------------------
+1 I'll commit after testing.
> mixed case tablename on lefthand side of LATERAL VIEW results in query failing with confusing error message
> -----------------------------------------------------------------------------------------------------------
>
> Key: HIVE-1857
> URL: https://issues.apache.org/jira/browse/HIVE-1857
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Affects Versions: 0.6.0
> Reporter: John Sichi
> Assignee: John Sichi
> Fix For: 0.7.0
>
> Attachments: HIVE-1857.1.patch
>
>
> For the modified query below in lateral_view.q, the exception "org.apache.hadoop.hive.ql.parse.SemanticException: line 3:7 Invalid Table Alias or Column Reference myCol" is thrown. The query should succeed.
> SELECT myCol from tmp_PYANG_lv LATERAL VIEW explode(array(1,2,3)) myTab as myCol limit 3;
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1857) mixed case tablename on lefthand side
of LATERAL VIEW results in query failing with confusing error message
Posted by "Paul Yang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1857?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Paul Yang updated HIVE-1857:
----------------------------
Resolution: Fixed
Status: Resolved (was: Patch Available)
Committed. Thanks John!
> mixed case tablename on lefthand side of LATERAL VIEW results in query failing with confusing error message
> -----------------------------------------------------------------------------------------------------------
>
> Key: HIVE-1857
> URL: https://issues.apache.org/jira/browse/HIVE-1857
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Affects Versions: 0.6.0
> Reporter: John Sichi
> Assignee: John Sichi
> Fix For: 0.7.0
>
> Attachments: HIVE-1857.1.patch
>
>
> For the modified query below in lateral_view.q, the exception "org.apache.hadoop.hive.ql.parse.SemanticException: line 3:7 Invalid Table Alias or Column Reference myCol" is thrown. The query should succeed.
> SELECT myCol from tmp_PYANG_lv LATERAL VIEW explode(array(1,2,3)) myTab as myCol limit 3;
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-1857) mixed case tablename on lefthand side
of LATERAL VIEW results in query failing with confusing error message
Posted by "Paul Yang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1857?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12973400#action_12973400 ]
Paul Yang commented on HIVE-1857:
---------------------------------
Taking a look..
> mixed case tablename on lefthand side of LATERAL VIEW results in query failing with confusing error message
> -----------------------------------------------------------------------------------------------------------
>
> Key: HIVE-1857
> URL: https://issues.apache.org/jira/browse/HIVE-1857
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Affects Versions: 0.6.0
> Reporter: John Sichi
> Assignee: John Sichi
> Fix For: 0.7.0
>
> Attachments: HIVE-1857.1.patch
>
>
> For the modified query below in lateral_view.q, the exception "org.apache.hadoop.hive.ql.parse.SemanticException: line 3:7 Invalid Table Alias or Column Reference myCol" is thrown. The query should succeed.
> SELECT myCol from tmp_PYANG_lv LATERAL VIEW explode(array(1,2,3)) myTab as myCol limit 3;
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1857) mixed case tablename on lefthand side
of LATERAL VIEW results in query failing with confusing error message
Posted by "John Sichi (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1857?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
John Sichi updated HIVE-1857:
-----------------------------
Status: Patch Available (was: Open)
Fix is in HIVE-1857.1.patch.
> mixed case tablename on lefthand side of LATERAL VIEW results in query failing with confusing error message
> -----------------------------------------------------------------------------------------------------------
>
> Key: HIVE-1857
> URL: https://issues.apache.org/jira/browse/HIVE-1857
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Affects Versions: 0.6.0
> Reporter: John Sichi
> Assignee: John Sichi
> Fix For: 0.7.0
>
> Attachments: HIVE-1857.1.patch
>
>
> For the modified query below in lateral_view.q, the exception "org.apache.hadoop.hive.ql.parse.SemanticException: line 3:7 Invalid Table Alias or Column Reference myCol" is thrown. The query should succeed.
> SELECT myCol from tmp_PYANG_lv LATERAL VIEW explode(array(1,2,3)) myTab as myCol limit 3;
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.