registerTable problem about singlestore-spark-connector HOT 7 CLOSED

Hi Zell, I am curious about the error that was raised, namely Table not found: Clienti. Notice the i at the end of the table name? Can you verify that you didn't try selecting from Clienti when you meant to select from Client?

Once you have verified that can you try running memsqlContext.table("MyDB.Client") and see if that gives you back the table reference you want?

from singlestore-spark-connector.

Hi Carl,
I renamed DB name and table name from Italian to English for write this issue.
In my tests all names were correct.

If I try:

memsqlContext.table("MyDB.Client")

the result is:

org.apache.spark.sql.AnalysisException: Specifying database name or other qualifiers are not allowed for temporary tables. If the table name has dots (.) in it, please quote the table name with backticks (`).;

and this error also happens if I try

memsqlContext.table(memsqlContext.tableNames().head)

and

memsqlContext.table("`MyDB`.`Client`")

from singlestore-spark-connector.

I appreciate you checking on that. Just wanted to rule out the base case first. :)

Today I tried to reproduce your issue, and was unable to. I also notice that in my version of Spark/Connector running something like memsqlContext.table("MyDB.Client") works as expected. It sounds like you are running a different version of something than I.

My version of Spark is: 1.5.1
My version of the Connector is: 1.2.1

Can you check on your versions? Also if possible can you use the MemSQL Spark Distribution which has been certified to work with the latest version of the connector? You can get the MemSQL Spark Distribution from here: http://versions.memsql.com/memsql-spark/latest

Thanks

from singlestore-spark-connector.

Ok, I was using spark 1.6.0.
Now I have downgrade at 1.5.1 and it work correctly.
Maybe It's a good idea to add this info in Readme.
Thanks a lot!

from singlestore-spark-connector.

Awesome to hear the issue has been resolved. You are completely right - we don't have good dependency documentation in this project. I will update the readme to reflect that. Thank you.

from singlestore-spark-connector.

I got the same issue. I don't want to downgrade the spark version . Is there any way i can use with spark 1.6 ?

from singlestore-spark-connector.

@pmuthal this project is compiled against spark 1.5.2 - see #24 for more context on the roadmap

from singlestore-spark-connector.