Hi Johnny, would you mind running sqoop again with parameter --verbose and sending entire output?
Jarcec On Fri, Feb 24, 2012 at 10:57:26AM -0500, Tolliver, Johnny S. wrote: > Hello all, > > I'm new to sqoop. I'm using CDH3U2 and testing sqoop against a GreenPlum > database. I've successfully imported two smallish tables into Hive without > problems, but on a third table, which is only slightly more complicated, I'm > getting the error > > column name '........pg.dropped.16........' not in table > > I've tried with both the postgresql driver version 8.4-703 and 9.1-901 and > get the same errors. > > I've also tried create-hive-table instead of import and get a different > error. This time a NullPointerException at > com.cloudera.sqoop.hive.TableDefWriter.getCreateTableStat at line 151. Same > results with both postgresql drivers. > > The table I'm trying to import has 15 columns and is not complicated. Here is > a create table command used in GreenPlum with the names changed to protect > the innocent. > > CREATE TABLE XXX ( > aaa varchar(2) NOT NULL, > fff varchar(5) NULL, > link numeric(8, 0) NOT NULL, > rrr varchar(1) NULL, > ident varchar(20) NULL, > xxx varchar(1) NULL, > cnty varchar(3) NULL, > zzz varchar(5) NULL, > hhh varchar(12) NULL, > ccc varchar(12) NULL, > date1 datetime NULL, > date2 datetime NULL, > id2 varchar(9) NULL, > ind varchar(1) NULL, > eee varchar(1) NULL, > xref varchar(12) NULL > ) > > Anyone have any ideas why I'm seeing these errors? Many thanks. >
signature.asc
Description: Digital signature
