Sqoop Error - Insufficient space for shared memory file: 31730

sqoop

#1

[vanampudi@gw01 ~]$ sqoop list-tables --connect “jdbc:mysql://ms.itversity.com:3306/retail_db” --username retail_user --password itversity

Warning: /usr/hdp/2.5.0.0-1245/accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
Java HotSpot™ 64-Bit Server VM warning: Insufficient space for shared memory file:
31730
Try using the -Djava.io.tmpdir= option to select an alternate temp location.

Exception in thread “main” java.lang.RuntimeException: Could not create temporary directory: /tmp/sqoop-vanampudi/compile/885e64d84293c252d087dd5c1eacc994; check for a directory permissions issue on /tmp.
at org.apache.sqoop.SqoopOptions.getNonceJarDir(SqoopOptions.java:909)
at org.apache.sqoop.SqoopOptions.initDefaults(SqoopOptions.java:979)
at org.apache.sqoop.SqoopOptions.(SqoopOptions.java:376)
at com.cloudera.sqoop.SqoopOptions.(SqoopOptions.java:77)
at org.apache.sqoop.Sqoop.(Sqoop.java:85)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:224)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)
at org.apache.sqoop.Sqoop.main(Sqoop.java:243)

Thanks
Venkat


#2

Please use the below command:

sqoop list-tables --connect "jdbc:mysql://ms.itversity.com:3306/hr_db" --username hr_user --password itversity


#3

Hi Vinod,

In the above Jdbc connection we are using “hr_db” before username .

Why we are using hr_db here ?

hr_dba is this Databae name in MYSQL ?

Can some one tell me how to connect to Teradata from sqoop and load the data into HDFS ?

Thanks .

Regards,
Srinivasarao


#4

For retail db the user name is retail_dba not for hr_db.

To connect Tera Data from sqoop, below link will be helpful.

https://community.hortonworks.com/articles/53531/importing-data-from-teradata-into-hive.html


#5