Xindian Long created PHOENIX-3460: ------------------------------------- Summary: Phoenix Spark plugin cannot find table with a Namespace prefix Key: PHOENIX-3460 URL: https://issues.apache.org/jira/browse/PHOENIX-3460 Project: Phoenix Issue Type: Bug Affects Versions: 4.8.0 Environment: HDP 2.5 Reporter: Xindian Long Fix For: 4.7.0
I am testing some code using Phoenix Spark plug in to read a Phoenix table with a namespace prefix in the table name (the table is created as a phoenix table not a hbase table), but it returns an TableNotFoundException. The table is obviously there because I can query it using plain phoenix sql through Squirrel. In addition, using spark sql to query it has no problem at all. I am running on the HDP 2.5 platform, with phoenix 4.7.0.2.5.0.0-1245 The problem does not exist at all when I was running the same code on HDP 2.4 cluster, with phoenix 4.4. Neither does the problem occur when I query a table without a namespace prefix in the DB table name, on HDP 2.5 The log is in the attached file: tableNoFound.txt My testing code is also attached. The weird thing is in the attached code, if I run testSpark alone it gives the above exception, but if I run the testJdbc first, and followed by testSpark, both of them work. After changing to create table by using create table ACME.ENDPOINT_STATUS The phoenix-spark plug in seems working. I also find some weird behavior, If I do both the following create table ACME.ENDPOINT_STATUS ... create table "ACME:ENDPOINT_STATUS" ... Both table shows up in phoenix, the first one shows as Schema ACME, and table name ENDPOINT_STATUS, and the later on shows as scheme none, and table name ACME:ENDPOINT_STATUS. However, in HBASE, I only see one table ACME:ENDPOINT_STATUS. In addition, upserts in the table ACME.ENDPOINT_STATUS show up in the other table, so is the other way around. -- This message was sent by Atlassian JIRA (v6.3.4#6332)