March 2015 ~ tips and tricks

Monday, March 2, 2015

Solution to Failed to execute command Create Sqoop Database on service Sqoop 2 error

7:19 AM By Ongun Demirler BigData, Cloudera, linux, Sqoop No comments

Depending on java configuration Sqoop2 database creation may fail to update derby drivers and may get "Failed to execute command Create Sqoop Database on service Sqoop 2" error.

To solve this apply following steps:

1. Download derby derby client from db-derby-10.11.1.1-bin.zip

2. Extract and copy derby.jar and derbyclient.jar from zip file to /var/lib/sqoop2

3. Copy derby.jar to /opt/cloudera/parcels/CDH-<version>/jars/ as well

4. Delete /opt/cloudera/parcels/CDH-<version>/lib/sqoop2/webapps/sqoop/WEB-INF/lib/derby-<version>.jar soft link.

5. Make /opt/cloudera/parcels/CDH-<version>/lib/sqoop2/webapps/sqoop/WEB-INF/lib/derby.jar to /opt/cloudera/parcels/CDH-<version>/jars/derby.jar

Trendy List
- UC4 status messages - AH_STATUS
  
  Unfortunately UC4 (Automic) software does not have any lookup table for ah_status values. These are the ah_status messages I stumbled upon...
- Informatica Certification - Informatica PowerCenter Data Integration 9.x:Developer Specialist Certification Preparation Guide
  
  After I got my Informatica PowerCenter Data Integration 9.x:Developer Specialist Certificate, I want to share my preparation experience with...
- How to query Table - Column comments in Sybase IQ
  
  Table and cloumn comments can be queried from sys.systables and sys.syscolumns system views in Sybase IQ. Comments are stored in remarks c...
- How to move binary (raw) data with Informatica Power Center
  
  Although Power Center shows this as possible, unfortunately you can not move binary or raw columns from source to target normally. You can t...
- Sybase IQ equavalent for Oracle wm_concat and SQL group_concat
  
  Sybase IQ equavalent for Oracle wm_concat and SQL group_concat is LIST() function. This function takes 2 parameters column_name (mandot...
- SYBASE IQ - Split coma seperated values in to rows
  
  To split delimiter separated values in to rows use sa_split_list function Usage: SELECT * FROM sa_split_list( 'Tee Shirt,Baseba...
- Readable folder size command in IBM AIX
  
  to get folder size in readable format use du -gs *| sort -n click for SUN Solaris command
- Informatica Sybase IQ external loader with client side load option
  
  In default to load data to Sybase IQ with Informatica external loader you have to transfer data to Sybase server. With following code you ...
- UC4 Automic "Automatically deactivate when finished"
  
  You can use following SQL to query "Automatically deactivate when finished" status from UC4 repository. select OH_IDNR, OH_N...
- How to move data out of Informatica File Archive to Hadoop using sqoop
  
  Although it seem hard and complicated. Once you discovered correct connection string and driver name getting data out of Informatica file ar...

tips and tricks

Monday, March 2, 2015

Solution to Failed to execute command Create Sqoop Database on service Sqoop 2 error

Blog Archive

Labels

About Me

Total Pageviews

Trendy List