Hi All, I am using sqoop cdh3u3 along with Hadoop cdh3u2. I am trying to import a Oracle table but i get the following error: "ERROR tool.ImportTool: Imported Failed: Attempted to generate class with no columns!"
Here is the console snippet: [root@namenode ~]# sudo -u hdfs sqoop import --connect jdbc:oracle:thin:@dev_db:1521:RiskStg --username db_user --password db_password --table import_table_name --target-dir /user/hdfs -- verbose 12/02/21 09:50:47 DEBUG tool.BaseSqoopTool: Enabled debug logging. 12/02/21 09:50:47 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead. 12/02/21 09:50:47 DEBUG sqoop.ConnFactory: Loaded manager factory: com.cloudera.sqoop.manager.DefaultManagerFactory 12/02/21 09:50:47 DEBUG sqoop.ConnFactory: Trying ManagerFactory: com.cloudera.sqoop.manager.DefaultManagerFactory 12/02/21 09:50:47 DEBUG manager.DefaultManagerFactory: Trying with scheme: jdbc:oracle:thin:@dev_db:1521 12/02/21 09:50:47 DEBUG manager.OracleManager$ConnCache: Instantiated new connection cache. 12/02/21 09:50:47 INFO manager.SqlManager: Using default fetchSize of 1000 12/02/21 09:50:47 DEBUG sqoop.ConnFactory: Instantiated ConnManager com.cloudera.sqoop.manager.OracleManager@1cb8deef 12/02/21 09:50:47 INFO tool.CodeGenTool: Beginning code generation 12/02/21 09:50:47 DEBUG manager.OracleManager: Using column names query: SELECT t.* FROM import_table_name t WHERE 1=0 12/02/21 09:50:47 DEBUG manager.OracleManager: Creating a new connection for jdbc:oracle:thin:@dev_db:1521:RiskStg, using username: db_user 12/02/21 09:50:47 DEBUG manager.OracleManager: No connection paramenters specified. Using regular API for making connection. 12/02/21 09:50:48 INFO manager.OracleManager: Time zone has been set to GMT 12/02/21 09:50:48 DEBUG manager.SqlManager: Using fetchSize for next query: 1000 12/02/21 09:50:48 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM import_table_name t WHERE 1=0 12/02/21 09:50:48 DEBUG manager.OracleManager$ConnCache: Caching released connection for jdbc:oracle:thin:@dev_db:1521:RiskStg/db_user 12/02/21 09:50:48 DEBUG orm.ClassWriter: selected columns: 12/02/21 09:50:48 ERROR tool.ImportTool: Imported Failed: Attempted to generate class with no columns! Also, I would like to know why sqoop is running a query which wont return any rows viz. "SELECT t.* FROM import_table_name t WHERE 1=0" Any help would be highly appreciated. Thanks, Anil
