Re: Handling CLOBs in Sqoop - Hive Import

2013-11-07 Thread Jarek Jarcec Cecho
Hi Rahul, sadly the parameter --hive-drop-import-delims is applicable only for String based types (such as CHAR, VARCHAR, NCHAR, ...), it's not applicable to CLOB. To workaround this, you can re-type the CLOB field into String using --map-column-java parameter, such as: sqoop import --map-col

Re: Handling CLOBs in Sqoop - Hive Import

2013-11-06 Thread Rahul Joshi
Hi, We are trying to use Sqoop for importing data from Oracle. The table has CLOB as one of its column type which contains newline characters at many places. Tried using --hive-drop- import-delims option but somehow it’s not working. The data still contains newlines, and so Hive table doesn’t re

Handling CLOBs in Sqoop - Hive Import

2013-11-06 Thread Rahul Joshi
Hi, We are trying to use Sqoop for importing data from Oracle. The table has CLOB as one of its column type which contains newline characters at many places. Tried using --hive-drop- import-delims option but somehow it’s not working. The data still contains newlines, and so Hive table doesn’t re