Hi all, Please forgive if i violate any rule before posting in this mailing list . I am using for some testing in my hadoop standalone set up.
Hadoop Version: 0.20.2-cdh3u5, 580d1d26c7ad6a7c6ba72950d8605e2c6fbc96cc Sqoop Version : Sqoop 1.4.1-incubating Also tried : Sqoop 1.4.0-incubating Postgresql Versio : edb-psql (9.0.4.14) I am able to export data from HDFS to postgresql but when I am trying to import data from DB to hdfs , below problem arises : hadoop@test123:~/project/ sqoop-1.4.1-incubating__hadoop-0.20$ bin/sqoop import --connect jdbc:postgresql://localhost/hadooppipeline --table test_table --username postgres --password postgres Warning: /usr/lib/hbase does not exist! HBase imports will fail. Please set $HBASE_HOME to the root of your HBase installation. 12/08/23 19:25:19 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead. 12/08/23 19:25:19 INFO manager.SqlManager: Using default fetchSize of 1000 12/08/23 19:25:19 INFO tool.CodeGenTool: Beginning code generation 12/08/23 19:25:19 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM "test_table" AS t LIMIT 1 12/08/23 19:25:19 ERROR orm.ClassWriter: Cannot resolve SQL type 2003 12/08/23 19:25:19 ERROR orm.ClassWriter: Cannot resolve SQL type 2003 12/08/23 19:25:19 ERROR orm.ClassWriter: Cannot resolve SQL type 2003 12/08/23 19:25:19 ERROR orm.ClassWriter: Cannot resolve SQL type 2003 12/08/23 19:25:19 ERROR orm.ClassWriter: Cannot resolve SQL type 2003 12/08/23 19:25:19 ERROR orm.ClassWriter: Cannot resolve SQL type 2003 12/08/23 19:25:19 ERROR orm.ClassWriter: No Java type for SQL type 2003 for column rc_list There are 4 bigint columns in the table. Please guide me if Sqoop support for bigint columns or not. I do some Rn D and find only one link but not able to solve the issue : https://issues.cloudera.org/browse/SQOOP-48?page=com.atlassian.jira.plugin.system.issuetabpanels%3Aall-tabpanel Thanks
