Support Questions
Find answers, ask questions, and share your expertise

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

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

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

 

Explorer
Yes it worked!