HI Alex, Please try with uppercase username along with upper case TableName.
Thanks, Anil On Sun, Mar 11, 2012 at 5:02 AM, Alex Rovner <arov...@proclivitymedia.com>wrote: > Jagat, > > I forgot to mention that I have tried both upper case and lowercase table > names with no success. Run with uppercase below: > > [arovner@haiti sqoop]$ bin/sqoop import --connect > jdbc:oracle:thin:@10.0.137.102:1521:MRC2 --username XXXX --password XXX > --table BUILD_NODE --hive-import --hive-overwrite --hive-table build_node > --num-mappers 1 --map-column-hive CLIENT_TID=bigint,MERCHANDISE_TID=bigint > --target-dir /tmp/tables/build_node > Warning: /usr/lib/hbase does not exist! HBase imports will fail. > Please set $HBASE_HOME to the root of your HBase installation. > 12/03/11 08:01:19 WARN tool.BaseSqoopTool: Setting your password on the > command-line is insecure. Consider using -P instead. > 12/03/11 08:01:19 INFO tool.BaseSqoopTool: Using Hive-specific delimiters > for output. You can override > 12/03/11 08:01:19 INFO tool.BaseSqoopTool: delimiters with > --fields-terminated-by, etc. > 12/03/11 08:01:19 INFO manager.SqlManager: Using default fetchSize of 1000 > 12/03/11 08:01:19 INFO tool.CodeGenTool: Beginning code generation > 12/03/11 08:01:20 INFO manager.OracleManager: Time zone has been set to GMT > 12/03/11 08:01:20 INFO manager.SqlManager: Executing SQL statement: SELECT > t.* FROM BUILD_NODE t WHERE 1=0 > 12/03/11 08:01:20 ERROR tool.ImportTool: Imported Failed: Attempted to > generate class with no columns! > > Thanks > Alex > > > On Sun, Mar 11, 2012 at 12:16 AM, Jagat <jagatsi...@gmail.com> wrote: > >> Dear Alex >> >> The Oracle table name has to be given in upper case. >> >> The same has been documented in the Sqoop user guide. >> >> You can read more about it at link below. >> >> >> http://incubator.apache.org/sqoop/docs/1.4.1-incubating/SqoopUserGuide.html#_oracle_case_sensitive_catalog_query_errors >> >> Thanks >> >> Jagat >> >> On Sun, Mar 11, 2012 at 7:24 AM, Alex Rovner <arov...@proclivitymedia.com >> > wrote: >> >>> Getting the below error when specifying "--table" argument. Specifying >>> the "--query" works though. Reading through email archives some one >>> suggested that the table names are case sensitive in oracle so I have >>> verified that the case is correct. >>> >>> Using latest from trunk. Any ideas? >>> >>> [arovner@haiti sqoop]$ bin/sqoop version >>> Warning: /usr/lib/hbase does not exist! HBase imports will fail. >>> Please set $HBASE_HOME to the root of your HBase installation. >>> Sqoop 1.4.2-incubating-SNAPSHOT >>> git commit id 8b39345360c7c4e2982bfa25c27321 >>> ad9882357f >>> Compiled by arovner on Sat Mar 10 15:07:11 EST 2012 >>> >>> >>> >>> [arovner@haiti sqoop]$ bin/sqoop import --connect >>> jdbc:oracle:thin:@10.0.137.102:1521:MRC2 --username XXXX --password >>> XXXX --table build_node --hive-import --hive-overwrite --hive-table >>> build_node --target-dir /tmp/build_node --num-mappers 1 >>> Warning: /usr/lib/hbase does not exist! HBase imports will fail. >>> Please set $HBASE_HOME to the root of your HBase installation. >>> 12/03/10 15:21:53 WARN tool.BaseSqoopTool: Setting your password on the >>> command-line is insecure. Consider using -P instead. >>> 12/03/10 15:21:53 INFO tool.BaseSqoopTool: Using Hive-specific >>> delimiters for output. You can override >>> 12/03/10 15:21:53 INFO tool.BaseSqoopTool: delimiters with >>> --fields-terminated-by, etc. >>> 12/03/10 15:21:53 INFO manager.SqlManager: Using default fetchSize of >>> 1000 >>> 12/03/10 15:21:53 INFO tool.CodeGenTool: Beginning code generation >>> 12/03/10 15:21:54 INFO manager.OracleManager: Time zone has been set to >>> GMT >>> 12/03/10 15:21:54 INFO manager.SqlManager: Executing SQL statement: >>> SELECT t.* FROM build_node t WHERE 1=0 >>> 12/03/10 15:21:54 ERROR tool.ImportTool: Imported Failed: Attempted to >>> generate class with no columns! >>> >>> >>> Proclivity® | We Value Your Customers™ >>> >>> This message is the property of Proclivity Systems, Inc. and is intended >>> only for the use of the addressee(s), and may contain material that is >>> confidential and privileged for the sole use of the intended recipient. If >>> you are not the intended recipient, reliance or forwarding without express >>> permission is strictly prohibited; please contact the sender and delete all >>> copies. >> >> >> > > Proclivity® | We Value Your Customers™ > > This message is the property of Proclivity Systems, Inc. and is intended > only for the use of the addressee(s), and may contain material that is > confidential and privileged for the sole use of the intended recipient. If > you are not the intended recipient, reliance or forwarding without express > permission is strictly prohibited; please contact the sender and delete all > copies. -- Thanks & Regards, Anil Gupta