Hi All, We are using netezza direct to import data from Netezza to Hadoop as part of POC.
Q1. Does direct mode always require CREATE EXTERNAL TABLE and DROP privilege to perform direct transfer? Q2. Does the *external table* get created in Netezza ? If yes, which database ? I see Sqoop using below query : CREATE EXTERNAL TABLE '/yarn/local/usercache/someuser/appcache/application_ 1483624176418_42787/work/task_1483624176418_42787_m_000000/nzexttable-0.txt' USING (REMOTESOURCE 'JDBC' BOOLSTYLE 'T_F' CRINSTRING FALSE DELIMITER 44 ENCODING 'internal' FORMAT 'Text' INCLUDEZEROSECONDS TRUE NULLVALUE 'null' MAXERRORS 1) AS SELECT * FROM SOME_TBL WHERE (DATASLICEID % 3) Q3. If Netezza needs to create External tables, can it create the external table in different database than the one which the actual table with data that needs to be pulled into Hadoop. Q4. Does Sqoop run DROP table on external table which was created by individual mappers ? I have limited knowledge on External table. Above question will solve lot of doubts w.r.t implementation. Thanks in advance.! -- Thanks Suraj Nayak M
