{"action":"created","issue":{"url":"https://api.github.com/repos/memsql/memsql-spark-connector/issues/11","labels_url":"https://api.github.com/repos/memsql/memsql-spark-connector/issues/11/labels{/name}","comments_url":"https://api.github.com/repos/memsql/memsql-spark-connector/issues/11/comments","events_url":"https://api.github.com/repos/memsql/memsql-spark-connector/issues/11/events","html_url":"https://github.com/memsql/memsql-spark-connector/issues/11","id":126383841,"number":11,"title":"registerTable problem","user":{"login":"zell147258","id":5516689,"avatar_url":"https://avatars.githubusercontent.com/u/5516689?v=3","gravatar_id":"","url":"https://api.github.com/users/zell147258","html_url":"https://github.com/zell147258","followers_url":"https://api.github.com/users/zell147258/followers","following_url":"https://api.github.com/users/zell147258/following{/other_user}","gists_url":"https://api.github.com/users/zell147258/gists{/gist_id}","starred_url":"https://api.github.com/users/zell147258/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zell147258/subscriptions","organizations_url":"https://api.github.com/users/zell147258/orgs","repos_url":"https://api.github.com/users/zell147258/repos","events_url":"https://api.github.com/users/zell147258/events{/privacy}","received_events_url":"https://api.github.com/users/zell147258/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-01-13T10:07:17Z","updated_at":"2016-01-14T08:10:36Z","closed_at":null,"body":"I have a MemSQL cluster. I tried connect to it and read some data from a Table but when I select my table the program throw this exception:\r\n```\r\nException in thread \"main\" org.apache.spark.sql.AnalysisException: Table not found: Clienti;\r\n\tat org.apache.spark.sql.catalyst.analysis.package$AnalysisErrorAt.failAnalysis(package.scala:42)\r\n\tat org.apache.spark.sql.catalyst.analysis.Analyzer$ResolveRelations$.getTable(Analyzer.scala:306)\r\n```\r\n\r\nI tried different ways to do this: \r\n```\r\nobject LoadTestSpark extends App {\r\n  val conf = new SparkConf().setAppName(\"MemSQL Example\")\r\n  conf.set(\"memsql.host\", \"192.168.3.12\")\r\n  conf.setMaster(\"local[1]\")\r\n  val sparkContext = new SparkContext(conf)\r\n  val memsqlContext = new MemSQLContext(sparkContext)\r\n  memsqlContext.setDatabase(\"MyDB\")\r\nmemsqlContext.sql(\"select * from Client\").registerTempTable(\"client\")\r\n}\r\n```\r\n\r\n```\r\nobject LoadTestSpark extends App {\r\n  val conf = new SparkConf().setAppName(\"MemSQL Example\")\r\n  conf.set(\"memsql.host\", \"192.168.3.12\")\r\n  conf.setMaster(\"local[1]\")\r\n  val sparkContext = new SparkContext(conf)\r\n  val memsqlContext = new MemSQLContext(sparkContext)\r\n  memsqlContext.setDatabase(\"MyDB\")\r\n  val client = memsqlContext.table(\"Client\")\r\n}\r\n```\r\n\r\nbut in both cases it does not work.\r\n\r\nIf i run this: \r\n```\r\n...\r\nmemsqlContext.tableNames().foreach(println)\r\n...\r\n```\r\nthe output is:\r\n```\r\n...\r\n`MyDB`.`Checkup_dati`\r\n`MyDB`.`Chiamate_blocchi`\r\n`MyDB`.`Cicli`\r\n`MyDB`.`Classificazioni`\r\n`MyDB`.`Client`\r\n....\r\n\r\nwhat can I do for load data from my tables?"},"comment":{"url":"https://api.github.com/repos/memsql/memsql-spark-connector/issues/comments/171568014","html_url":"https://github.com/memsql/memsql-spark-connector/issues/11#issuecomment-171568014","issue_url":"https://api.github.com/repos/memsql/memsql-spark-connector/issues/11","id":171568014,"user":{"login":"zell147258","id":5516689,"avatar_url":"https://avatars.githubusercontent.com/u/5516689?v=3","gravatar_id":"","url":"https://api.github.com/users/zell147258","html_url":"https://github.com/zell147258","followers_url":"https://api.github.com/users/zell147258/followers","following_url":"https://api.github.com/users/zell147258/following{/other_user}","gists_url":"https://api.github.com/users/zell147258/gists{/gist_id}","starred_url":"https://api.github.com/users/zell147258/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zell147258/subscriptions","organizations_url":"https://api.github.com/users/zell147258/orgs","repos_url":"https://api.github.com/users/zell147258/repos","events_url":"https://api.github.com/users/zell147258/events{/privacy}","received_events_url":"https://api.github.com/users/zell147258/received_events","type":"User","site_admin":false},"created_at":"2016-01-14T08:10:36Z","updated_at":"2016-01-14T08:10:36Z","body":"Hi Carl, \r\nI renamed DB name and table name from Italian to English for write this issue. \r\nIn my tests all names were correct.\r\n\r\nIf I try:\r\n```\r\nmemsqlContext.table(\"MyDB.Client\")\r\n```\r\nthe result is: \r\n```\r\norg.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 (`).;\r\n```\r\nand this error also happens if I try\r\n```\r\nmemsqlContext.table(memsqlContext.tableNames().head)\r\n```\r\nand \r\n```\r\nmemsqlContext.table(\"`MyDB`.`Client`\")\r\n```\r\n\r\n\r\n"}}