[jira] Commented: (HIVE-1973) Getting error when join on tables where name of table has uppercase letters

["Chinna Rao Lalam (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-1973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12997791#comment-12997791 ] 

Chinna Rao Lalam commented on HIVE-1973:
----------------------------------------


1) In method parseJoinCondPopulateAlias present in SemanticAnalyzer.java  table name (tabForJoin) is converted to lower-case and compared using equals() with the actual name so it returned false and it resulted in the exception. 

So instead of comparing with the actual name convert that to lower-case and compare.

2) In genJoinOperator() present in SemanticAnalyzer.java retrieving the operator from the  map using the table name but map contains the table name with lower-case so it returns null.

So while getting from the map give the name with lower-case.

> 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
>
> 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