Ashish Kumar Sinha created SQOOP-3287: -----------------------------------------
Summary: Import to HDFS not working in parquet not working for LDAP SQL Server Key: SQOOP-3287 URL: https://issues.apache.org/jira/browse/SQOOP-3287 Project: Sqoop Issue Type: Bug Components: connectors/sqlserver, sqoop2-jdbc-connector Affects Versions: 1.4.6 Reporter: Ashish Kumar Sinha I am importing data from SQL Server to HDFS. Seems there is a bug when autnetication mode is LDAP and format is parquet. Please let me know if this is a bug or I am doing incorrectly. I am using Cloudera distribution. Below different scenarios I have tested Command Used are. 1) SQL Server (Native Connection) -> HDFS Text Format *(WORKS FINE)* sqoop import \ --connect "jdbc:sqlserver://<<ServerName>>;databasename=<<DB_Name>>" --username xxxx \ --password xxxx \ --table 'table1' \ --split-by col1 \ --target-dir /user/user1/01/ 2) SQL Server (Native Connection) -> HDFS Parquet Format *(WORKS FINE)* sqoop import \ --connect "jdbc:sqlserver://<<ServerName>>;databasename=<<DB_Name>>" --username xxxx \ --password xxxx \ --table 'table1' \ --split-by col1 \ --target-dir /user/user1/01/ \ --as-parquetfile 3) SQL Server (LDAP Connection) -> HDFS Text format (*WORKS FINE*) sqoop import \ --connect "jdbc:jtds:sqlserver://<<Server2>>;useNTLMv2=true;domain=XXXX;databaseName=<<DB_name>>" \ --connection-manager org.apache.sqoop.manager.SQLServerManager --driver net.sourceforge.jtds.jdbc.Driver \ --username xxxx \ --password xxxx \ --table table2 \ --target-dir /user/user1/02/ \ -- --schema=s1 4) SQL Server (LDAP Connection) -> HDFS Parquet format (*Executes successfully, but the exported files are not parquet, they are in TEXT format*) sqoop import \ --connect "jdbc:jtds:sqlserver://<<Server2>>;useNTLMv2=true;domain=XXXX;databaseName=<<DB_name>>" \ --connection-manager org.apache.sqoop.manager.SQLServerManager --driver net.sourceforge.jtds.jdbc.Driver \ --username xxxx \ --password xxxx \ --table table2 \ --target-dir /user/user1/02/ \ -- --schema=s1 \ --as-parquetfile -- This message was sent by Atlassian JIRA (v7.6.3#76005)