Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-1091

Support string functions like UPPER, LOWER, SUBSTRING in WHERE clause

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • v1.1
    • Backlog
    • Query Engine
    • None

    Description

      String functions are supported in the SELECT and GROUP BY clauses but not in the WHERE one.

      The exception being thrown is similar to the following:

      LOWER while executing SQL: "
      select lower(d.name), avg(f.my_measure)
      from fact_table f
      inner join dim_table d on f.fk_id = d.pk_id
      where lower(d.name) = 'my_username'
      group by lower(d.name)
      LIMIT 50000"

      Attachments

        Activity

          People

            liyang.gmt8@gmail.com liyang
            francescopalmiotto Francesco Palmiotto
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: