[jira] [Updated] (CARBONDATA-4175) Issue with array_contains after altering schema for array types

2021-04-26 Thread Akshay (Jira) 


 [ 
https://issues.apache.org/jira/browse/CARBONDATA-4175?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Akshay updated CARBONDATA-4175:
---
Description: NPE on executing filter query after adding array column to the 
carbon table

> Issue with array_contains after altering schema for array types
> ---
>
> Key: CARBONDATA-4175
> URL: https://issues.apache.org/jira/browse/CARBONDATA-4175
> Project: CarbonData
>  Issue Type: Bug
>  Components: spark-integration
>Reporter: Akshay
>Priority: Major
>
> NPE on executing filter query after adding array column to the carbon table



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

[jira] [Created] (CARBONDATA-4175) Issue with array_contains after altering schema for array types

2021-04-26 Thread Akshay (Jira) 
Akshay created CARBONDATA-4175:
--

 Summary: Issue with array_contains after altering schema for array 
types
 Key: CARBONDATA-4175
 URL: https://issues.apache.org/jira/browse/CARBONDATA-4175
 Project: CarbonData
  Issue Type: Bug
  Components: spark-integration
Reporter: Akshay






--
This message was sent by Atlassian Jira
(v8.3.4#803005)

[jira] [Resolved] (CARBONDATA-4172) Select query having parent and child struct column in projection returns incorrect results

2021-04-26 Thread Kunal Kapoor (Jira) 


 [ 
https://issues.apache.org/jira/browse/CARBONDATA-4172?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Kunal Kapoor resolved CARBONDATA-4172.
--
Fix Version/s: 2.2.0
   Resolution: Fixed

> Select query having  parent and child struct column in projection returns 
> incorrect results
> ---
>
> Key: CARBONDATA-4172
> URL: https://issues.apache.org/jira/browse/CARBONDATA-4172
> Project: CarbonData
>  Issue Type: Bug
>Reporter: Indhumathi Muthumurugesh
>Priority: Major
> Fix For: 2.2.0
>
>  Time Spent: 1h 40m
>  Remaining Estimate: 0h
>
> struct column: col1 struct
> insert: named_struct('a',1,'b',2,'c','a')
> Query : select col1,col1.a from table;
> Result:
> col1 col1.a
> {a:1,b:null,c:null}  1



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

[jira] [Resolved] (CARBONDATA-4174) Handle exception for desc column

2021-04-26 Thread Ajantha Bhat (Jira) 


 [ 
https://issues.apache.org/jira/browse/CARBONDATA-4174?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Ajantha Bhat resolved CARBONDATA-4174.
--
Fix Version/s: 2.2.0
   Resolution: Fixed

> Handle exception for desc column
> 
>
> Key: CARBONDATA-4174
> URL: https://issues.apache.org/jira/browse/CARBONDATA-4174
> Project: CarbonData
>  Issue Type: Bug
>Reporter: SHREELEKHYA GAMPA
>Priority: Minor
> Fix For: 2.2.0
>
>
> Validation not present for children column in desc column for a primitive 
> datatype and higher level non existing children column desc column for a 
> complex datatype
> drop table if exists complexcarbontable; create table complexcarbontable 
> (deviceInformationId int,channelsId string,ROMSize string,purchasedate 
> string,mobile struct,MAC array,gamePointId 
> map,contractNumber double) STORED AS carbondata;
> describe column deviceInformationId.x on complexcarbontable; describe column 
> channelsId.x on complexcarbontable;
> describe column mobile.imei.x on complexcarbontable; describe column 
> MAC.item.x on complexcarbontable; describe column gamePointId.key.x on 
> complexcarbontable;
> [Expected Result] :- Validation should be provided for children column in 
> desc column for a primitive datatype and higher level non existing children 
> column desc column for a complex datatype. Command execution should fail.
> [Actual Issue] : - Validation not present for children column in desc column 
> for a primitive datatype and higher level non existing children column desc 
> column for a complex datatype. As a result the command execution is 
> successful.
> [!https://clouddevops.huawei.com/vision-file-storage/api/file/download/upload-v2/2021/3/21/c71035/7a3b04d78ceb4a489e6c038f4bb257db/image.png!|https://clouddevops.huawei.com/vision-file-storage/api/file/download/upload-v2/2021/3/21/c71035/7a3b04d78ceb4a489e6c038f4bb257db/image.png]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

[jira] [Resolved] (CARBONDATA-4173) Fix inverted index query issue

2021-04-26 Thread Ajantha Bhat (Jira) 


 [ 
https://issues.apache.org/jira/browse/CARBONDATA-4173?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Ajantha Bhat resolved CARBONDATA-4173.
--
Fix Version/s: 2.2.0
   Resolution: Fixed

> Fix inverted index query issue
> --
>
> Key: CARBONDATA-4173
> URL: https://issues.apache.org/jira/browse/CARBONDATA-4173
> Project: CarbonData
>  Issue Type: Bug
>Reporter: SHREELEKHYA GAMPA
>Priority: Minor
> Fix For: 2.2.0
>
>  Time Spent: 3h
>  Remaining Estimate: 0h
>
>  select query with filter column which is present in inverted_index column 
> does not return any value
> From Spark beeline/SQL/Shell execute the following queries
> drop table if exists uniqdata6;
> CREATE TABLE uniqdata6(cust_id int,cust_name string,ACTIVE_EMUI_VERSION 
> string, DOB timestamp, DOJ timestamp, BIGINT_COLUMN1 bigint,BIGINT_COLUMN2 
> bigint,DECIMAL_COLUMN1 decimal(30,10), DECIMAL_COLUMN2 
> decimal(36,10),Double_COLUMN1 double, Double_COLUMN2 double, INTEGER_COLUMN1 
> int)stored as carbondata TBLPROPERTIES ('sort_columns'='CUST_ID,CUST_NAME', 
> 'inverted_index'='CUST_ID,CUST_NAME','sort_scope'='global_sort');
> LOAD DATA INPATH 'hdfs://hacluster/chetan/2000_UniqData.csv' into table 
> uniqdata6 OPTIONS ('FILEHEADER'='CUST_ID,CUST_NAME 
> ,ACTIVE_EMUI_VERSION,DOB,DOJ, 
> BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1, 
> Double_COLUMN2,INTEGER_COLUMN1','BAD_RECORDS_ACTION'='FORCE');
> select cust_name from uniqdata6 limit 5;
> select * from uniqdata6 where CUST_NAME='CUST_NAME_2';
> select * from uniqdata6 where CUST_NAME='CUST_NAME_3';
>  
> [Expected Result] :- select query with filter column which is present in 
> inverted_index column should return correct value
> [Actual Issue] : - select query with filter column which is present in 
> inverted_index column does not return any value
> [!https://clouddevops.huawei.com/vision-file-storage/api/file/download/upload-v2/2021/3/15/c71035/05443c9a9c11457e947645f1cf0ad347/image.png!|https://clouddevops.huawei.com/vision-file-storage/api/file/download/upload-v2/2021/3/15/c71035/05443c9a9c11457e947645f1cf0ad347/image.png]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)