(1)导入数据时报错:The field value in row "1423" and column "9" cannot be converted to a PACKED DECIMAL value. A null was loaded.数据:1,1,1,0.17,BC,ESEOUGHTATION,IbMDGQOmqoU,50000.0,10.0,-10.0,1,0,hXpilFCYqbfyfICWi,qNxHxDSElxSql,NktTdSIkijpUmCJ...
显示全部(1)导入数据时报错:
The field value in row "1423" and column "9" cannot be converted to
a PACKED DECIMAL value. A null was loaded.
数据:1,1,1,0.17,BC,ESEOUGHTATION,IbMDGQOmqoU,50000.0,10.0,-10.0,1,0,hXpilFCYqbfyfICWi,qNxHxDSElxSql,NktTdSIkijpUmCJknz,ZP,123456789,(732)744-1700,2016-01-25 01:19:49.87700,OE,eMGjTfQsAZfdHRHnVWqzgUKocckTZUKBCboLDsuwQDzmtldYubtLyyzkqqfZUMqJWsanktexRXmLmcgQThVAkJHNytWuWQYvqlESzEZVTRqBfVdZbaOnUSOJvXMFbebKWRneRfXswzlquCWpjGbBQrUNfxEoHligfJMZPpsFIAhJkfxoTftGPAuzEAVGzgFpMXCpqPxP,
表结构是其他数据转换过来,表结构:
create table benchmarksql.customer (
c_w_id integer not null,
c_d_id integer not null,
c_id integer not null,
c_discount decimal(4,4),
c_credit char(2),
c_last varchar(16),
c_first varchar(30),
c_credit_lim decimal(12,2),
c_balance decimal(18,3),
c_ytd_payment float,
c_payment_cnt integer,
c_delivery_cnt integer,
c_street_1 varchar(20),
c_street_2 varchar(20),
c_city varchar(20),
c_state char(2),
c_zip char(9),
c_phone char(16),
c_since timestamp,
c_middle char(2),
c_data varchar(200)
)
(2)导入报错
数据:
1|1|1|1|1|1|2016-01-25 01:19:49.87700|10.0|RHlgikbYCf|
2|2|1|1|1|1|2016-01-25 01:19:49.99700|10.0|qSPTblGanlcESxSZlk|
3|3|1|1|1|1|2016-01-25 01:19:49.99700|10.0|PGMGbSVkRbKPZrpK|
4|4|1|1|1|1|2016-01-25 01:19:49.99800|10.0|gLCdPtfTKHZPmH|
5|5|1|1|1|1|2016-01-25 01:19:49.99800|10.0|QSxGtIPmiCajTVQkgE|
6|6|1|1|1|1|2016-01-25 01:19:49.99900|10.0|AvqrfjOeLCjcfVPATfG
表结构:
create table benchmarksql.history (
hist_id int not null primary key,
h_c_id integer,
h_c_d_id integer,
h_c_w_id integer,
h_d_id integer,
h_w_id integer,
h_date timestamp,
h_amount decimal(6,2),
h_data varchar(24)
)"
收起