[GitHub] [incubator-doris] xinyi-spark opened a new issue #2511: insert into import cross partitions error

[GitBox <gi...@apache.org>]

xinyi-spark opened a new issue #2511: insert into import cross partitions error
URL: https://github.com/apache/incubator-doris/issues/2511
 
 
   Table partition by day, when import for more than 5 days at a time, see error:
   >ERROR 1064 (HY000): For input string: "2361759245". url:  XXX
   
   every line print error in the url:
   >Reason: null value for not null column, column=partition_stat_date. src line: []; 
   
   E.g: 
   >insert into table_new partition(p20191101) select xxx from table_old WHERE stat_date >= 20191001 and stat_date <= 20191007
   
   Bug, split the day into two sql and import twice can import succeeded
   E.g: 
   >insert into table_new partition(p20191101) select xxx from table_old WHERE stat_date >= 20191001 and stat_date <= 20191005
   
   >insert into table_new partition(p20191101) select xxx from table_old WHERE stat_date >= 20191006 and stat_date <= 20191007
   
   separate execution can succeed

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org