中国电信网站备案系统,常德网站制作,天津哪家公司做企业网站,wordpress 不显侧边背景#xff1a;使用sqoop import 才oracle抽数据入HDFS后#xff0c;通过pxf建立hawq外表#xff0c;查询数据报错
解决思路#xff1a;1、从报错上看应该是数据源分割后字段数比目标表字段多#xff0c;且pgadmin3里报错还出现源数据异常的一条记录#xff0c;去源头o…背景使用sqoop import 才oracle抽数据入HDFS后通过pxf建立hawq外表查询数据报错
解决思路1、从报错上看应该是数据源分割后字段数比目标表字段多且pgadmin3里报错还出现源数据异常的一条记录去源头oracle查看对应的记录发现地段内部包含分隔符。 2、重新执行sqoop import 并用 \t 分隔问题解决。 Loading Data from a Flat File ERROR: Extra Data after Last Expected Column
Chloe Jackson
March 23, 2017 16:26Environment Product Version Pivotal Greenplum 4.2.x OS All Supported OS Symptom Loading data from flat files result in the following error message: ERROR: extra data after last expected columnCause You will encounter this error if your source data has more columns than the target table. Resolution You must ensure that the source data and table columns align. Example: -- Target table ddata# \d empTable public.emp
Column Type Modifiers
----------------------------
id integer
dept integer
role integer
Distributed by: (id)-- Source data file $ cat /tmp/load.dat
1234
1234
1234
1234
1234
1234--Error ddata# copy emp from /tmp/load.dat with delimiter as ;
ERROR: extra data after last expected column (seg0 sdw1:55001
pid12476)
CONTEXT: COPY emp, line 1: 1234As can be seen from the example above, the source data file has one more column than the target table, resulting in the error described above. 官方给出的解决方案如下
