carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Akash R Nilugal (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CARBONDATA-2113) Count(*) and select * are not working on old store with V2 format
Date Fri, 02 Feb 2018 06:59:00 GMT

     [ 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)

Mime
View raw message