Uploaded image for project: 'Tajo (Retired)'
  1. Tajo (Retired)
  2. TAJO-228

Can't use group by column alias

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Duplicate
    • None
    • 0.2-incubating
    • None
    • None

    Description

      I ran the bellow query which uses column alias and group by.

      select b.n_name as nation, count(*) as cnt
  from customer_100 a, nation_100 b 
 where a.c_nationkey = b.n_nationkey 
 group by b.n_name
 order by cnt desc
 limit 7

      This query doesn't end. I found attached error message in tajo worker's log.

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. TAJO-226 Can't use group by column alias

          • Major - Major loss of function.
          • Resolved

          Activity

            People

              Unassigned Unassigned
              babokim kim hyoung jun
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: