Notes for SQOOP and ORACLE Interaction

When SQOOP interacts with ORACLE, the user name and table name must be of the same size. Otherwise, no results will be displayed. As follows: [hadoop @ htbbs bin] $. /sqoop list-tables -- connect "jdbc: oracle: thin: @ htbbs: 1521: htdb" -- username YANSP -- password testWarning:/usr/lib/hbase does not exist! HBase imports will fail. please set $ HBASE_HOME to the root of your HBase installation. warning: $ HADOOP_HOME is deprecated. 13/05/20 15:25:13 WARN tool. baseSqoopTool: Setting your password on the command-line is insecure. consider using-P instead.13/05/20 15:25:13 INFO manager. sqlManager: Using default fetchSize of 100013/05/20 15:25:13 INFO manager. oracleManager: Time zone has been set to GMTTTES TODCH_EXT_TABLE [hadoop @ htbbs bin] $. /sqoop list-tables -- connect "jdbc: oracle: thin: @ htbbs: 1521: htdb" -- username yansp -- password testWarning:/usr/lib/hbase does not exist! HBase imports will fail. please set $ HBASE_HOME to the root of your HBase installation. warning: $ HADOOP_HOME is deprecated. 13/05/20 15:26:59 WARN tool. baseSqoopTool: Setting your password on the command-line is insecure. consider using-P instead.13/05/20 15:26:59 INFO manager. sqlManager: Using default fetchSize of 100013/05/20 15:26:59 INFO manager. oracleManager: Time zone has been set to GMT [had Oop @ htbbs bin] $ the user name is in lowercase and no results are displayed. It can be in uppercase. This is because in ORACLE, usernames and table names are stored in the database in upper case by default. SQL> show userUSER is "YANSP" SQL> select table_name from user_tables; TABLE_NAME------------------------------------------------------------TTESTODCH_EXT_TABLE SQL> select username from USER_USERS; USERNAME------------------------------------------------------------YANSP SQL>