Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Not A Problem
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Query Processor
    • Labels:
      None

      Description

      hive> create table src (key string, value string);           
      OK
      Time taken: 0.096 seconds
      hive> select * from src join src on (src.key == src.key);    
      FAILED: Error in semantic analysis: Line 1:23 Ambiguous table alias 'src'
      

        Activity

        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Resolved Resolved
        4h 27m 1 John Sichi 18/Oct/11 15:17
        John Sichi made changes -
        Field Original Value New Value
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Not A Problem [ 8 ]
        Hide
        John Sichi added a comment -

        What kalyan said.

        Show
        John Sichi added a comment - What kalyan said.
        Hide
        kalyan ram added a comment -

        Isn't it an alias issue ? The src.key can't be resolved. The below one works.

        select * from src s1 join src s2 on (s1.key == s2.key);

        Show
        kalyan ram added a comment - Isn't it an alias issue ? The src.key can't be resolved. The below one works. select * from src s1 join src s2 on (s1.key == s2.key);
        Ashutosh Chauhan created issue -

          People

          • Assignee:
            Unassigned
            Reporter:
            Ashutosh Chauhan
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development