My Oracle Support Banner

Unable to Set Queue for Sqoop Hcatalog Job Imports on BDA 4.x (Doc ID 2003305.1)

Last updated on APRIL 26, 2015

Applies to:

Big Data Appliance Integrated Software - Version 4.1.0 and later
Linux x86-64


Prior to BDA 4.x, can be used in the sqoop command to specify a pool for the job to run in. However in BDA 4.x, the value is getting ignored and the jobs  run in the default pool. 

Exporting in the HADOOP_OPTS environment variable has no effect.

For example, the command ingors

sqoop import -Dmapreduce.output.fileoutputformat.compress=true -Dmapreduce.output.fileoutputformat.compress.type=BLOCK -Doraoop.chunk.method=ROWID -Doraoop.timestamp.string=false -Doraoop.import.partitions=SYS_P4385 --direct --connect jdbc:oracle:thin:@// --table TABNAME.XXXXXX --map-column-hive TRANSACTION_ITEM_FID=bigint,TRANSACTION_FID=bigint,PROD_ID=bigint,PROD_HIST_ID=bigint,STORE_ID=bigint,STORE_HIST_ID=bigint,CARD_ID=bigint,CARD_HIST_ID=bigint,DATE_ID=bigint,TIME_ID=bigint,CURRENCY_ID=bigint,TERMINAL_ID=bigint,TERMINAL_HIST_ID=bigint,PROMO_CYCLE_ID=bigint,TRANSACTION_DTTM=timestamp,LOAD_ID=bigint,CREATED_DTTM=timestamp,MODIFIED_DTTM=timestamp,BASKET_SAMPLE_SEED_NUM=tinyint,LOAD_FILE_DATE=timestamp --m 48 --create-hcatalog-table --hcatalog-database kroger_mc_p --hcatalog-table transaction_item_fct_mc_raw_xxxxx --compression-codec --compress --delete-target-dir --username USERNAME[NAME] --password-file /user/xxxx/xxxx


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.