CODEWITHSUNDEEP
rhana
PRIYA
PRIYA

Reputation: 11

How to fetch data from hana to R.my codes are showing error

I am fetching data table to R from hana but it is showing some kind of error.

Succesfully integrated and odbc got connected but data is not fetching.

sqlFetch(ch,'SELECT * FROM "MY_SCHEMA.TICKETS_BY_YEAR"')

Error in odbcTableExists(channel, sqtable) : ‘SELECT * FROM "MY_SCHEMA.TICKETS_BY_YEAR"’: table not found on channel

i expected for the data but it is not coming

Upvotes: 0

Views: 166

Answers (1)

Lars Br.
Lars Br.

Reputation: 10396

The cause of the error message is the wrong use of double-quotes (“).
To correctly quote the schema name and the table name, each of them need to be enclosed in a couple of quotation marks like so:

   FROM “SCHEMA_NAME”.”TABLE_NAME”
        ^           ^ ^          ^

Your command in R needs to look like this:

sqlFetch(ch, 'SELECT * FROM "MY_SCHEMA”.”TICKETS_BY_YEAR"')

Upvotes: 1

Related Questions