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] [Created] (CARBONDATA-1915) In the insert into and the update flow when static values are inserted then the preferred locations are coming empty
Date Wed, 20 Dec 2017 04:56:00 GMT
Akash R Nilugal created CARBONDATA-1915:
-------------------------------------------

             Summary: In the insert into and the update flow when static values are inserted
then the preferred locations are coming empty
                 Key: CARBONDATA-1915
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-1915
             Project: CarbonData
          Issue Type: Bug
            Reporter: Akash R Nilugal
            Assignee: Akash R Nilugal
            Priority: Minor


【Test step】:
CREATE TABLE carbon_01(imei string,age int,task bigint,num double,level decimal(10,3),productdate
timestamp)STORED BY 'org.apache.carbondata.format';
CREATE TABLE carbon_02(imei string,age int,task bigint,num double,level decimal(10,3),productdate
timestamp,name string,point int)STORED BY 'org.apache.carbondata.format';
LOAD DATA INPATH 'hdfs://hacluster/mytest/moredata01.csv'  INTO TABLE carbon_02 options ('DELIMITER'=',',
'QUOTECHAR'='"','FILEHEADER' = 'imei,age,task,num,level,productdate,name,point');
insert into carbon_01 select imei,age,task,num,level,productdate from carbon_02 where age
is not NULL;
show segments for table carbon_01;
select * from carbon_01;
update carbon_01 set (imei) = ("RNG") where age <=0;
select * from carbon_01;
update carbon_01 set (imei) = ("SSG") where num in (15.5);
select * from carbon_01;
delete from carbon_01 where imei IN ('RNG','SSG');
select * from carbon_01;

result:update the table,then query table sometimes need long time to output result,or sometimes
failed,if query failed,the JDBCServer master/standby will be changed

update table then query table should working




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message