Link to question in Stack Overflow : http://stackoverflow.com/questions/41903493/sqoop-direct-import-netezza-table-permissions
On Fri, Jan 27, 2017 at 1:31 PM, Suraj Nayak <[email protected]> wrote: > 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/someuse > r/appcache/application_1483624176418_42787/work/task_1483624 > 176418_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 > -- Thanks Suraj Nayak M
