Comments (7)
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.
Related Issues (20)
- zero date time behaviour connection property HOT 1
- Scala 2.11 is not supported in Spark 3.0.0 HOT 1
- Getting Mysql "Multiple statements detected in a single query." error. HOT 4
- ALTER TABLE xxx RENAME TO issue with memsql spark connector HOT 2
- Question on merge functionality HOT 2
- load balancing for data ingestion is not working with multi aggregators HOT 3
- V3 is too slow as compared to V2 HOT 29
- control max number of concurrent connections on save HOT 2
- avro Date format exception HOT 3
- load data to memsql table from Hadoop (HDFS) ORC files HOT 2
- support for spark 3.0.x.. HOT 1
- issue with number of partitions when we use spark.read HOT 8
- selective pushdown HOT 4
- SingleStore DB support Array<struct> column types ? HOT 2
- Is it possible to consume singleStore as streaming datasource HOT 1
- memsql connector supports keytab and principal for kerb authn
- Typo SingleStore
- supported features for singlestore-spark-connector_2.11.... HOT 1
- support partial column list when using .write() HOT 2
- Performance issue HOT 5
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from singlestore-spark-connector.