[
https://issues.apache.org/jira/browse/CARBONDATA-2113?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Akash R Nilugal updated CARBONDATA-2113:
----------------------------------------
Description:
Count(*) and select * are not working on old store of V2 format in 1.3.0
1) count * is giving zero, for old store after refresh
0: jdbc:hive2://X.X.X.X:22550/default> refresh table brinjal5;
+-----------++
|Result|
+-----------++
+-----------++
No rows selected (3.419 seconds)
0: jdbc:hive2://X.X.X.X:22550/default> select count(*) from brinjal5;
+-------------++
|count(1)|
+-------------++
|0|
+-------------++
was:
Count(*) and select * are not working on old store of V2 format in 1.3.0
1) count * is giving zero, for old store after refresh
0: jdbc:hive2://X.X.X.X:22550/default> refresh table brinjal5;
+----------+-+
|Result|
+----------+-+
+----------+-+
No rows selected (3.419 seconds)
0: jdbc:hive2://X.X.X.X:22550/default> select count(*) from brinjal5;
+------------+-+
|count(1)|
+------------+-+
|0|
+------------+-+
CREATE TABLE IF NOT EXISTS employee_c ( eid int, name String, salary String,
destination String, doj date, toj timestamp, abc decimal(8,2), test BIGINT )
stored by 'crbondata';
insert into employee_c select 1,'rev','1000','ban','1999-01-12','1999-02-10
05:25:00',123456.25,564789;
insert into employee_c select 2,'rev','1000','ban','2012-01-01','2012-02-10
05:25:00',123456.25,564789;
create table carbon_stream stored by 'carbondata'
TBLPROPERTIES('DICTIONARY_INCLUDE'='eid','DICTIONARY_EXCLUDE'='name','No_Inverted_Index'='name','SORT_SCOPE'='globalsort',
'streaming'='true') as select eid , name ,salary, destination, doj, toj, abc,
test from employee_c;
> Count(*) and select * are not working on old store with V2 format
> -----------------------------------------------------------------
>
> Key: CARBONDATA-2113
> URL: https://issues.apache.org/jira/browse/CARBONDATA-2113
> Project: CarbonData
> Issue Type: Bug
> Components: core
> Reporter: Akash R Nilugal
> Assignee: Akash R Nilugal
> Priority: Minor
> Fix For: 1.3.0
>
> Time Spent: 1h
> Remaining Estimate: 0h
>
> Count(*) and select * are not working on old store of V2 format in 1.3.0
>
> 1) count * is giving zero, for old store after refresh
> 0: jdbc:hive2://X.X.X.X:22550/default> refresh table brinjal5;
> +-----------++
> |Result|
> +-----------++
> +-----------++
> No rows selected (3.419 seconds)
> 0: jdbc:hive2://X.X.X.X:22550/default> select count(*) from brinjal5;
> +-------------++
> |count(1)|
> +-------------++
> |0|
> +-------------++
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
