I am using Sqoop2 to import data from Oracle to HDFS and using impala tables to query on that data. However when we import data from Oracle with Sqoop2, we are seeing data in HDFS with strings as single quote for example state is looking like 'MaryLand'. How do I take out single quote on string when I import data through Sqoop2? The idea is we want to run sqoop2 to imports and run impala queries on it.
Please see below impala query and you see 'CA' like that. Does sqoop2 when it move data in HDFS for strings does it put single quotes. If so I do I query without showing single quote or is there anyway while sqoop I can take out single quote. Please let us know.
select * from gis_designated_areas
'9' 'CA', 'California'
This means do I need to change sqoop from sqoop2. When why CDH5 providing sqoop2 as defualt service. Also is there any our option
Sorry to ask. . Whati s free-form query? Does this mean I need to run a query to remove quote on impala side and anything to do with Sqoop2 itself
Any example on both side will be great help
We are using sqoop2 for importing tables from Mysql to HDFS and using Hive to query over that. But Sqoop2 enclosing columns of string type with single Quotes.
How do I take out single quote on string when I import data through Sqoop2 ? Is there any option available to disable column enclosing ?