[jira] [Updated] (CARBONDATA-2113) Count(*) and select * are not working on old store with V2 format
[
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|
++-+
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;
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 |
+---+--+
> 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|
> ++-+
>
> 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;
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Updated] (CARBONDATA-2113) Count(*) and select * are not working on old store with V2 format
[
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)
[jira] [Updated] (CARBONDATA-2113) Count(*) and select * are not working on old store with V2 format
[ 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 > 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: 20m > 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)
[jira] [Updated] (CARBONDATA-2113) Count(*) and select * are not working on old store with V2 format
[ 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 was: Count(*) and select * are not working on old store with V2 format > 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 > > > Count(*) and select * are not working on old store of V2 format in 1.3.0 > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
