Have you cheked in /user directory? ... View more

Impala automatically converts STRING literals of the correct format into TIMESTAMP values. I belive you don`t need to convert to unix time    Timestamp values are accepted in the format YYYY-MM-DD HH:MM:SS.sssssssss, and can consist of just the date, or just the time, with or without the fractional second portion. For example, you can specify TIMESTAMP values such as' 2011-04-10', '21:48:01', or '2011-04-10 21:48:01.000' or '2011-04-10 21:48:01'       ... View more

1. For Impala Issue: Try to refresh metadata by using below command in Impala. invalidate metadata;   2.I am able to connect through Putty with ec2-user as userid. I ran the script and I get an error: -bash: import-all-tables: command not found   Are you able to invoke SQOOP ?   I am not sure which mysql db you are connecting. Thats why i mentioned you might need to change password, username and db name etc.     ... View more

1. Please refer to https://www.cloudera.com/content/www/en-us/developers/get-started-with-hadoop-tutorial/exercise-1.html for ingets ( Mysql to HDFS ). It is straignt forward only need to change the db name, user id, pasword, mysql driver location and you should be good.     2. For ODBC driver: Did you install from below link? http://www.cloudera.com/content/www/en-us/downloads/connectors/hive/odbc/2-5-16.html.html ... View more

sqoop import-all-tables \     -m {{cluster_data.worker_node_hostname.length}} \     --connect jdbc:mysql://{{cluster_data.manager_node_hostname}​}:3306/retail_db \     --username=retail_dba \     --password=cloudera \     --compression-codec=snappy \     --as-parquetfile \     --warehouse-dir=/user/hive/warehouse \     --hive-import   -m --> Expects no of mapper. May be your variable is not getting converted to numeric value   try 1 or 2 instead ie -m 1 @smarudai wrote: Hi,   I am trying to launch the below sqoop job from terminal editor but I am getting Error: expected numeric argument. Try --help for usage.   Please help.   sqoop import-all-tables \ -m {{cluster_data.worker_node_hostname.length}} \ --connect jdbc:mysql://{{cluster_data.manager_node_hostname}}:3306/retail_db \ --username=retail_dba \ --password=cloudera \ --compression-codec=snappy \ --as-parquetfile \ --warehouse-dir=/user/hive/warehouse \ --hive-import   Thanks, Sundar.     ... View more

if it is a VM and you are doing practice then follow below tasks Assumption: You are using SQLITE and not configured Hue with external database   fuser /var/lib/hue/desktop.db   It will give process id.   kill -9 processid Note: database location may vary based on your configuration ... View more

http://www.cloudera.com/content/cloudera/en/downloads/connectors/sqoop/oracle/v1-6.html ... View more

Here is an example for My SQL:  --connect jdbc:mysql://quickstart:3306/retail_db   I guess for Oracle you should use below format with replacement:   --connect jdbc:oracle:thin:@OracleServer:OraclePort:OracleSID OR --connect jdbc:oracle:thin:@//OracleServer:OraclePort/OracleService   Make sure you have installed Oracle Connector for Sqoop. ... View more

-P expects password : User should enter in the console Instead of -P use : --password your_password ... View more

Perfect. Worked like a charm. ... View more