Sqoop quoted column/table names

When you use Apache Sqoop if a column name of an RDBMS table (in my case Postgresql) needs to be quoted, use [escape_char] is \

sqoop import … –table your_tablename –columns “[escape_char]”[escape_char]“your_columnname[escape_char]”[escape_char]“”

Same usage can use for table name or other things.

10 Şubat 2015

Posted In: postgresql, quoted names, rdbms, sqoop

WP Twitter Auto Publish Powered By : XYZScripts.com