Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Sqoop double quotes query problems

Sqoop double quotes query problems

Explorer

I have a problem with the double quotes on this sqoop query:

select i.Number, i.Date,i.Station, i.lStation, 
count(*) ax, 1- Pd St  , b.Type from Leg jl, yLeg i, senger b, 
where jl.LegID = i.LegID and jl.rID = b.erID and b.gID = b.ID  and b.tus not in (1,4) group by Number, Date, tion, b.Type

how can i fixed? with some escape parameter

3 REPLIES 3

Re: Sqoop double quotes query problems

Master Guru
Yes, try escaping it with the backslash (\) or wrap the query in single
quotes (') while using double quotes (") within the query.

Re: Sqoop double quotes query problems

Explorer

 

Like that ?

 

\"1- Pd\" St

 

on the other hand i tried using simple quotes 

 

'


@Harsh J wrote:
Yes, try escaping it with the backslash (\) or wrap the query in single
quotes (') while using double quotes (") within the query.


@Harsh J wrote:
Yes, try escaping it with the backslash (\) or wrap the query in single
quotes (') while using double quotes (") within the query.



1- Pd' St

 

Re: Sqoop double quotes query problems

Explorer
Yes it worked!
Don't have an account?
Coming from Hortonworks? Activate your account here