John, Could you be more explicit about the problem you are referring to? I don't think Sqoop will automatically create the table and the insert command you've provided does work for me.
-Abe On Mon, Feb 17, 2014 at 6:07 PM, John Zhao <[email protected]> wrote: > When I run the following sqoop command > ./sqoop export --connect jdbc:postgresql://localhost:5432/miner_demo > --table golf_cap_col --export-dir /csv/golf_cap_col > --input-fields-terminated-by , --username miner_demo --password miner_demo > -m 1 -- --schema demo > > > The input table is like this: > CREATE TABLE demo.golf_cap_col(outlook text, temperature > integer,humidity integer,wind text, "*PLAY*" text) ; > INSERT INTO demo.golf_cap_col( outlook, temperature, humidity, wind, " > *PLAY*") VALUES ('sunny', 80, 81, 'false', 'no') > > > Does anyone have any idea about this ? Do you know whether this is an > open issue? > > John Zhao > > >
