Dear all, perhaps my understanding is incorrect but I'm trying to reload a table using sqoop import, that already exists in hive. My expectation is that besides overwriting the actual data, also the table will be dropped and recreated. A table structure can of course change and as sqoop cannot detect changes unless you are using the incremental option, it should assume that this will happen - thus dropping and recreating the table with the new structure. Also a change in for instance a delimiter used to separate records or attributes can happen. Currently the table is not recreated though. The ddl stays untouched and also the the comment when data has been loaded is not updated. Is this a bug or am I missing a command in my sqoop action? My sqoop action looks like this: <sqoop xmlns="uri:oozie:sqoop-action:0.4">
<arg>import</arg>
<arg>--connect</arg>
<arg>jdbc:sap://[server]:30015/?currentschema=[schema]</arg>
<arg>--username</arg>
<arg>[username]</arg>
<arg>--password-file</arg>
<arg>[pwd_location]</arg>
<arg>--driver</arg>
<arg>com.sap.db.jdbc.Driver</arg>
<arg>--query</arg>
<arg>SELECT * FROM "ZDLTABLES" WHERE $CONDITIONS</arg>
<arg>--hive-import</arg>
<arg>--hive-database</arg>
<arg>[hive_schema]</arg>
<arg>--hive-table</arg>
<arg>zdltables</arg>
<arg>--hive-delims-replacement</arg>
<arg>\040</arg>
<arg>--fields-terminated-by</arg>
<arg>\037</arg>
<arg>--hive-overwrite</arg>
<arg>--compress</arg>
<arg>--num-mappers</arg>
<arg>1</arg>
<name-node>[name_node]</name-node>
<job-tracker>[job_tracker]</job-tracker>
<property xmlns="">
<name>oozie.launcher.mapred.job.queue.name</name>
<value>default</value>
<source>programatically</source>
</property>
<property xmlns="">
<name>mapreduce.job.queuename</name>
<value>default</value>
<source>programatically</source>
</property>
</configuration>
</sqoop>
... View more
