Nihal kumar ojha created CARBONDATA-4248:
--------------------------------------------
Summary: Explain query with upper case column is throwing key not
found exception.
Key: CARBONDATA-4248
URL: https://issues.apache.org/jira/browse/CARBONDATA-4248
Project: CarbonData
Issue Type: Bug
Reporter: Nihal kumar ojha
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")
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
