Oracle SQL Connector for Hadoop Distributed File System (HDFS) Field Terminator Incorrect on Output (Doc ID 1566394.1)

Last updated on JULY 03, 2013

Applies to:

Oracle SQL Connector for Hadoop Distributed File System - Version 2.1.0 and later
Linux x86-64

Symptoms

Using Oracle SQL Connector for HDFS (OSCH) to access a Hadoop Cluster (which can be on the Oracle Big Data Appliance (BDA) V2.1.1) will result in an output field terminator set to the default value of ","(comma) if an incorrect field termintor property is used to set the field terminator to another i.e. non-default value. 

The field terminator property to use in an OSCH configuration file is:  oracle.hadoop.exttab.fieldTerminator

Using anything other than oracle.hadoop.exttab.fieldTerminator will result in an output field terminator with the default value of ","(comma).

For example trying to set the field terminator to tab (u0009) with an incorrectly spelled field terminator property like oracle.hadoop.exttabl.fieldTerminator:

<property>
      <name>oracle.hadoop.exttabl.fieldTerminator</name>
      <value>\u0009</value>
</property>

 
Will result in output which shows the default ","(comma) delimitor. Note that 0X'2c' represents a ","(comma):

Oracle SQL Connector for HDFS Release 2.0.1 - Production
...
                 
ORGANIZATION EXTERNAL
(
   TYPE ORACLE_LOADER
   DEFAULT DIRECTORY "MOVIE_DIR"
   ACCESS PARAMETERS
   (
...
     FIELDS TERMINATED BY 0X'2C'
     MISSING FIELD VALUES ARE NULL
...

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms