[jira] [Updated] (HIVE-2228) Can't use DB qualified column names in WHERE or GROUP BY clauses
[
https://issues.apache.org/jira/browse/HIVE-2228?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhenxiao Luo updated HIVE-2228:
---
Attachment: HIVE-2228.2.patch.txt
Can't use DB qualified column names in WHERE or GROUP BY clauses
Key: HIVE-2228
URL: https://issues.apache.org/jira/browse/HIVE-2228
Project: Hive
Issue Type: Bug
Components: Database/Schema, Query Processor, SQL
Affects Versions: 0.7.0
Reporter: Carl Steinbach
Assignee: Zhenxiao Luo
Attachments: HIVE-2228.1.patch.txt, HIVE-2228.2.patch.txt
Hive doesn't allow you to use DB qualified column names in the WHERE or GROUP
BY clauses. The workaround is to define a table alias:
{noformat}
hive CREATE DATABASE db1;
OK
hive CREATE TABLE db1.t(a INT, b INT);
OK
hive SELECT * FROM db1.t WHERE db1.t.a 100;
FAILED: Error in semantic analysis: Line 1:26 Invalid table alias or column
reference 'db1'
hive SELECT * FROM db1.t t WHERE t.a 100;
OK
hive SELECT * FROM db1.t GROUP BY db1.t.a;
FAILED: Error in semantic analysis: Line 1:29 Invalid table alias or column
reference 'db1'
hive SELECT * FROM db1.t t GROUP BY t.a;
OK
{noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2228) Can't use DB qualified column names in WHERE or GROUP BY clauses
[
https://issues.apache.org/jira/browse/HIVE-2228?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhenxiao Luo updated HIVE-2228:
---
Status: Patch Available (was: Open)
Can't use DB qualified column names in WHERE or GROUP BY clauses
Key: HIVE-2228
URL: https://issues.apache.org/jira/browse/HIVE-2228
Project: Hive
Issue Type: Bug
Components: Database/Schema, Query Processor, SQL
Affects Versions: 0.7.0
Reporter: Carl Steinbach
Assignee: Zhenxiao Luo
Attachments: HIVE-2228.1.patch.txt, HIVE-2228.2.patch.txt
Hive doesn't allow you to use DB qualified column names in the WHERE or GROUP
BY clauses. The workaround is to define a table alias:
{noformat}
hive CREATE DATABASE db1;
OK
hive CREATE TABLE db1.t(a INT, b INT);
OK
hive SELECT * FROM db1.t WHERE db1.t.a 100;
FAILED: Error in semantic analysis: Line 1:26 Invalid table alias or column
reference 'db1'
hive SELECT * FROM db1.t t WHERE t.a 100;
OK
hive SELECT * FROM db1.t GROUP BY db1.t.a;
FAILED: Error in semantic analysis: Line 1:29 Invalid table alias or column
reference 'db1'
hive SELECT * FROM db1.t t GROUP BY t.a;
OK
{noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2228) Can't use DB qualified column names in WHERE or GROUP BY clauses
[
https://issues.apache.org/jira/browse/HIVE-2228?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Namit Jain updated HIVE-2228:
-
Status: Open (was: Patch Available)
minor comments on phabricator
Can't use DB qualified column names in WHERE or GROUP BY clauses
Key: HIVE-2228
URL: https://issues.apache.org/jira/browse/HIVE-2228
Project: Hive
Issue Type: Bug
Components: Database/Schema, Query Processor, SQL
Affects Versions: 0.7.0
Reporter: Carl Steinbach
Assignee: Zhenxiao Luo
Attachments: HIVE-2228.1.patch.txt
Hive doesn't allow you to use DB qualified column names in the WHERE or GROUP
BY clauses. The workaround is to define a table alias:
{noformat}
hive CREATE DATABASE db1;
OK
hive CREATE TABLE db1.t(a INT, b INT);
OK
hive SELECT * FROM db1.t WHERE db1.t.a 100;
FAILED: Error in semantic analysis: Line 1:26 Invalid table alias or column
reference 'db1'
hive SELECT * FROM db1.t t WHERE t.a 100;
OK
hive SELECT * FROM db1.t GROUP BY db1.t.a;
FAILED: Error in semantic analysis: Line 1:29 Invalid table alias or column
reference 'db1'
hive SELECT * FROM db1.t t GROUP BY t.a;
OK
{noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2228) Can't use DB qualified column names in WHERE or GROUP BY clauses
[
https://issues.apache.org/jira/browse/HIVE-2228?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhenxiao Luo updated HIVE-2228:
---
Attachment: HIVE-2228.1.patch.txt
Can't use DB qualified column names in WHERE or GROUP BY clauses
Key: HIVE-2228
URL: https://issues.apache.org/jira/browse/HIVE-2228
Project: Hive
Issue Type: Bug
Components: Database/Schema, Query Processor, SQL
Affects Versions: 0.7.0
Reporter: Carl Steinbach
Assignee: Zhenxiao Luo
Attachments: HIVE-2228.1.patch.txt
Hive doesn't allow you to use DB qualified column names in the WHERE or GROUP
BY clauses. The workaround is to define a table alias:
{noformat}
hive CREATE DATABASE db1;
OK
hive CREATE TABLE db1.t(a INT, b INT);
OK
hive SELECT * FROM db1.t WHERE db1.t.a 100;
FAILED: Error in semantic analysis: Line 1:26 Invalid table alias or column
reference 'db1'
hive SELECT * FROM db1.t t WHERE t.a 100;
OK
hive SELECT * FROM db1.t GROUP BY db1.t.a;
FAILED: Error in semantic analysis: Line 1:29 Invalid table alias or column
reference 'db1'
hive SELECT * FROM db1.t t GROUP BY t.a;
OK
{noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2228) Can't use DB qualified column names in WHERE or GROUP BY clauses
[
https://issues.apache.org/jira/browse/HIVE-2228?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhenxiao Luo updated HIVE-2228:
---
Status: Patch Available (was: Open)
Can't use DB qualified column names in WHERE or GROUP BY clauses
Key: HIVE-2228
URL: https://issues.apache.org/jira/browse/HIVE-2228
Project: Hive
Issue Type: Bug
Components: Database/Schema, Query Processor, SQL
Affects Versions: 0.7.0
Reporter: Carl Steinbach
Assignee: Zhenxiao Luo
Attachments: HIVE-2228.1.patch.txt
Hive doesn't allow you to use DB qualified column names in the WHERE or GROUP
BY clauses. The workaround is to define a table alias:
{noformat}
hive CREATE DATABASE db1;
OK
hive CREATE TABLE db1.t(a INT, b INT);
OK
hive SELECT * FROM db1.t WHERE db1.t.a 100;
FAILED: Error in semantic analysis: Line 1:26 Invalid table alias or column
reference 'db1'
hive SELECT * FROM db1.t t WHERE t.a 100;
OK
hive SELECT * FROM db1.t GROUP BY db1.t.a;
FAILED: Error in semantic analysis: Line 1:29 Invalid table alias or column
reference 'db1'
hive SELECT * FROM db1.t t GROUP BY t.a;
OK
{noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2228) Can't use DB qualified column names in WHERE or GROUP BY clauses
[
https://issues.apache.org/jira/browse/HIVE-2228?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Carl Steinbach updated HIVE-2228:
-
Component/s: SQL
Database/Schema
Can't use DB qualified column names in WHERE or GROUP BY clauses
Key: HIVE-2228
URL: https://issues.apache.org/jira/browse/HIVE-2228
Project: Hive
Issue Type: Bug
Components: Database/Schema, Query Processor, SQL
Affects Versions: 0.7.0
Reporter: Carl Steinbach
Assignee: Zhenxiao Luo
Hive doesn't allow you to use DB qualified column names in the WHERE or GROUP
BY clauses. The workaround is to define a table alias:
{noformat}
hive CREATE DATABASE db1;
OK
hive CREATE TABLE db1.t(a INT, b INT);
OK
hive SELECT * FROM db1.t WHERE db1.t.a 100;
FAILED: Error in semantic analysis: Line 1:26 Invalid table alias or column
reference 'db1'
hive SELECT * FROM db1.t t WHERE t.a 100;
OK
hive SELECT * FROM db1.t GROUP BY db1.t.a;
FAILED: Error in semantic analysis: Line 1:29 Invalid table alias or column
reference 'db1'
hive SELECT * FROM db1.t t GROUP BY t.a;
OK
{noformat}
--
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] [Updated] (HIVE-2228) Can't use DB qualified column names in WHERE or GROUP BY clauses
[
https://issues.apache.org/jira/browse/HIVE-2228?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Carl Steinbach updated HIVE-2228:
-
Fix Version/s: (was: 0.8.0)
Can't use DB qualified column names in WHERE or GROUP BY clauses
Key: HIVE-2228
URL: https://issues.apache.org/jira/browse/HIVE-2228
Project: Hive
Issue Type: Bug
Components: Query Processor
Affects Versions: 0.7.0
Reporter: Carl Steinbach
Hive doesn't allow you to use DB qualified column names in the WHERE or GROUP
BY clauses. The workaround is to define a table alias:
{noformat}
hive CREATE DATABASE db1;
OK
hive CREATE TABLE db1.t(a INT, b INT);
OK
hive SELECT * FROM db1.t WHERE db1.t.a 100;
FAILED: Error in semantic analysis: Line 1:26 Invalid table alias or column
reference 'db1'
hive SELECT * FROM db1.t t WHERE t.a 100;
OK
hive SELECT * FROM db1.t GROUP BY db1.t.a;
FAILED: Error in semantic analysis: Line 1:29 Invalid table alias or column
reference 'db1'
hive SELECT * FROM db1.t t GROUP BY t.a;
OK
{noformat}
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2228) Can't use DB qualified column names in WHERE or GROUP BY clauses
[
https://issues.apache.org/jira/browse/HIVE-2228?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Carl Steinbach updated HIVE-2228:
-
Fix Version/s: 0.8.0
Can't use DB qualified column names in WHERE or GROUP BY clauses
Key: HIVE-2228
URL: https://issues.apache.org/jira/browse/HIVE-2228
Project: Hive
Issue Type: Bug
Components: Query Processor
Affects Versions: 0.7.0
Reporter: Carl Steinbach
Fix For: 0.8.0
Hive doesn't allow you to use DB qualified column names in the WHERE or GROUP
BY clauses. The workaround is to define a table alias:
{noformat}
hive CREATE DATABASE db1;
OK
hive CREATE TABLE db1.t(a INT, b INT);
OK
hive SELECT * FROM db1.t WHERE db1.t.a 100;
FAILED: Error in semantic analysis: Line 1:26 Invalid table alias or column
reference 'db1'
hive SELECT * FROM db1.t t WHERE t.a 100;
OK
hive SELECT * FROM db1.t GROUP BY db1.t.a;
FAILED: Error in semantic analysis: Line 1:29 Invalid table alias or column
reference 'db1'
hive SELECT * FROM db1.t t GROUP BY t.a;
OK
{noformat}
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
