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

        

Reply via email to