[ https://issues.apache.org/jira/browse/HIVE-1973?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-1973: ----------------------------- Resolution: Fixed Hadoop Flags: [Reviewed] Status: Resolved (was: Patch Available) Committed. Thanks Chinna Rao Lalam > Getting error when join on tables where name of table has uppercase letters > --------------------------------------------------------------------------- > > Key: HIVE-1973 > URL: https://issues.apache.org/jira/browse/HIVE-1973 > Project: Hive > Issue Type: Bug > Components: Query Processor > Affects Versions: 0.5.0, 0.7.0 > Environment: Hadoop 0.20.1, Hive0.5.0 and SUSE Linux Enterprise > Server 10 SP2 (i586) - Kernel 2.6.16.60-0.21-smp (5). > Reporter: Chinna Rao Lalam > Assignee: Chinna Rao Lalam > Attachments: HIVE-1973.patch > > > When execute a join query on tables containing Uppercase letters in the table > names hit an exception > Ex: > {noformat} > create table a(b int); > create table tabForJoin(b int,c int); > select * from a join tabForJoin on(a.b=tabForJoin.b); > Got an exception like this > FAILED: Error in semantic analysis: Invalid Table Alias tabForJoin > {noformat} > But if i give without capital letters ,It is working -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira