Uploaded image for project: 'CarbonData'
  1. CarbonData
  2. CARBONDATA-4248

Explain query with upper case column is throwing key not found exception.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 2.2.0
    • None
    • None

    Description

      Steps to reproduce:

      sql("drop table if exists carbon_table")
      sql("drop table if exists parquet_table")
      sql("create table IF NOT EXISTS carbon_table(`BEGIN_TIME` BIGINT," +
      " `SAI_CGI_ECGI` STRING) stored as carbondata")
      sql("create table IF NOT EXISTS parquet_table(CELL_NAME string, CGISAI string)" +
      " stored as parquet")
      sql("explain extended with grpMainDatathroughput as (select" +
      " from_unixtime(begin_time, 'yyyyMMdd') as data_time, SAI_CGI_ECGI from carbon_table)," +
      " grpMainData as (select * from grpMainDatathroughput a JOIN(select CELL_NAME, CGISAI from" +
      " parquet_table) b ON b.CGISAI=a.SAI_CGI_ECGI) " +
      "select * from grpMainData a left join grpMainData b on a.cell_name=b.cell_name")

      Attachments

        Activity

          People

            Unassigned Unassigned
            nihal Nihal kumar ojha
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 6h 10m
                6h 10m