Page History

  public static final String NULL_FIELD = "NULL";

ARRAY

• Will be encoded as String (and hence enclosed with '\, inside there will be JSON encoding of the top level array elements (hence the entire value will be enclosed in [] pair), Nested values are not JSON encoded..
• Few examples:
  • Array of FixedPoint '[1,2,3]'
  • Array of Text '["A","B","C"]'
  • Array of Objects of type FixedPoint '["[11, 12]","[14, 15]"]'
  • Array of Objects of type Text '["[A, B]","[X, Y]"]' 

Refer https://issues.apache.org/jira/browse/SQOOP-1771 for more details

BINARY

BIT

true, TRUE, 1

false, FALSE, 0

( not encoded in quotes )

Unsupported values should throw an exception

java boolean

DATE

DATE_TIME

YYYY-MM-DD HH:MM:DD[.ZZZ][+/-XX] ( fraction and timezone are optional)

Refer https://issues.apache.org/jira/browse/SQOOP-1846 for more details

org.joda.time. DateTime

or

org.joda.time. LocalDateTime

(depends on timezone attribute )

DECIMAL

BigDecimal (not encoded in quotes ),

java BigDecimal

scale and precision fields are handled via :

https://issues.apache.org/jira/browse/SQOOP-2027

ENUM

FIXED_POINT

Integer or Long, ( not encoded in quotes )

java Integer

or

java Long

( depends on

byteSize attribute

and signed attribute)

https://issues.apache.org/jira/browse/SQOOP-2022

FLOATING_POINT

java Double

or

java Float

( depends on

byteSize attribute)

https://issues.apache.org/jira/browse/SQOOP-2022

MAP

• Will be encoded as String (and hence enclosed with '\, inside there will be JSON encoding of the map (hence the entire value will be enclosed in  pair { }, nested values are also encoded as JSON
• Map<Number, Number> '{1:20}'
• Map<String, String> - '{"testKey":"testValue"}'
  
  
  Refer https://issues.apache.org/jira/browse/SQOOP-1771 for more details

SET

java Object[]

TEXT

Entire string will be enclosed in single quotes and all bytes will be printed as they are will exception of following bytes

TIME

HH:MM:DD[.ZZZ] ( fraction is optional )

3 digit milli second support only for time

UNKNOWN