Reply
Explorer
Posts: 11
Registered: ‎07-16-2015

Sqoop double quotes query problems

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

Posts: 1,885
Kudos: 422
Solutions: 298
Registered: ‎07-31-2013

Re: Sqoop double quotes query problems

Yes, try escaping it with the backslash (\) or wrap the query in single
quotes (') while using double quotes (") within the query.
Explorer
Posts: 11
Registered: ‎07-16-2015

Re: Sqoop double quotes query problems

 

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
Posts: 12
Registered: ‎06-15-2018

Re: Sqoop double quotes query problems

Yes it worked!
Announcements
New solutions