Sqoop chestunte issue

[nuzvid_mamidikaya]

table name "group" ani undi. sql server DB. As "group" is keyword it is failing with following issue

 

 ERROR manager.SqlManager: Error executing statement: java.sql.SQLException: Incorrect syntax near the keyword 'Group'.

 

tried using  ' ' , ` `, \  but no luck. any one having any idea?

[MeetFriendz]

illa try cheye 

[Group]

[Quickgun_murugan]

https://stackoverflow.com/questions/9229611/how-to-use-sqoop-in-java-program

[MeetFriendz]

[schema_name].[table_name]

[nuzvid_mamidikaya]

7 minutes ago, MeetFriendz said:

illa try cheye 

[Group]

tried it. No luck bro

[tacobell fan]

11 minutes ago, Quickgun_murugan said:

https://stackoverflow.com/questions/9229611/how-to-use-sqoop-in-java-program

nuvvu legend andhuke ayyav Muraga.. nuvvu deni meeda work chestav?

[MeetFriendz]

 

near group annadu kabatii some thing around hit must have issue .. check .. me not into sqoop or sql server 

 

https://stackoverflow.com/questions/21070894/get-jdbc-sqlserverexception-incorrect-syntax-near-error-when-exececute-pr

[mettastar]

use double quotes .. usually when column names are keywords we use double quotes .. so try that way it may work 

like 

SELECT 

"A" 

FROM "GROUP" 

[nuzvid_mamidikaya]

6 minutes ago, mettastar said:

use double quotes .. usually when column names are keywords we use double quotes .. so try that way it may work 

like 

SELECT 

"A" 

FROM "GROUP" 

will try and update. thanks

[m0nster]

1 hour ago, Quickgun_murugan said:

https://stackoverflow.com/questions/9229611/how-to-use-sqoop-in-java-program

Neku telindhi ami ledha kaka

[Quickgun_murugan]

3 minutes ago, m0nster said:

Neku telindhi ami ledha kaka

Friday em plans kaka.. weekend ki

[m0nster]

15 minutes ago, Quickgun_murugan said:

Friday em plans kaka.. weekend ki

Plans am levu kaka, Mukka chukka anthe,.

 

Nuvvu?

[Biskot]

2 hours ago, nuzvid_mamidikaya said:

table name "group" ani undi. sql server DB. As "group" is keyword it is failing with following issue

 

 ERROR manager.SqlManager: Error executing statement: java.sql.SQLException: Incorrect syntax near the keyword 'Group'.

 

tried using  ' ' , ` `, \  but no luck. any one having any idea?

ltt

[sdpp143]

Try this for table.    \`group\`  

[nuzvid_mamidikaya]

22 minutes ago, sdpp143 said:

Try this for table.    \`group\`  

already tried bro. no luck