Stack Overflow
Stack Overflow

Questions tagged [apache-phoenix]

For questions about Apache Phoenix. For the Elixir web framework, use phoenix-framework.

For questions about Apache Phoenix. For the Elixir web framework, use .

702 questions
0
votes
1 answer

Null values for Integer/Decimal datatype in Phoenix

I am creating Phoenix table with few integer/decimal column has been defined as Null but when we are getting data with null values in these columns then these records are getting rejected out. Null value in the varchar , char & Date datatype are…
PKumar
  • 1
  • 2
0
votes
1 answer

Drop schema containing tables in HBase using Phoenix

How can I drop a schema that contains tables in HBase using Phoenix? HBase version :1.2.6 Phoenix Version : 4.10.0-Hbase-1.2.0 I am trying to drop a schema, but I'm unable to do it. My schema consists of some tables. I get an error that the…
Vishal Biradar
  • 1,219
  • 2
  • 12
  • 24
0
votes
3 answers

unable to create schema in hbase using phoenix

I am using Phoenix verion :4.10.0-HBase-1.2 I am getting below error while creating new schema: Inconsistent namespace mapping properites.. Ensure that config phoenix.schema.isNamespaceMappingEnabled is consitent on client and …
Vishal Biradar
  • 1,219
  • 2
  • 12
  • 24
0
votes
1 answer

read hbase table salted with phoenix in hive with hbase serde

I have created an hbase table with Phoenix SQL create table query and also specified salt_buckets. Salting adds prefix to the the rowkey as expected. I have created an external hive table to map to this hbase table with hbase serde The problem is…
jujulala
  • 1
  • 2
0
votes
1 answer

Class org.apache.phoenix.mapreduce.PhoenixOutputFormat not found

Team.When I run a program on a spark cluster to save RDD to phoenix, I always report this error. as follows: 17/06/12 09:35:46 ERROR kerberos.SaveAsPhoenixApp$: save to phoenix error :java.lang.RuntimeException: java.lang.ClassNotFoundException:…
jifei yang
  • 1
  • 4
0
votes
1 answer

How to get a ddl of an existing table using apache pheonix

This is possible with oracl sql developer. I want that same functionality in pheonix is that possible Ddl along with dcl statements
Asiri Liyana Arachchi
  • 2,663
  • 5
  • 24
  • 43
0
votes
1 answer

Apache Phoenix CURRENT_TIME() gives NPE

I am attempting to use Apache Phoenix's filter on timestamp column. My table and column exists. The column is of type TIMESTAMP. https://phoenix.apache.org/language/datatypes.html#timestamp_type 0: jdbc:phoenix:localhost:2181:/hbase> SELECT * FROM…
bearrito
  • 2,217
  • 1
  • 25
  • 36
0
votes
1 answer

Read HBase data into Spark via Apache Phoenix

Being a noob to working with Spark, Phoenix and HBase, was a trying a few examples, as listed out here and here. Created the data as per the example for "us_population" here. However, on trying to query the Table thus created in Phoenix / HBase, via…
vsdaking
  • 476
  • 9
  • 22
0
votes
0 answers

Hbase CallTimeoutException

I'm running Hbase 1.1.2/Hadoop 2.7.1/phoenix-4.8.0. I'm trying to run a scan on a table but I'm getting RPC timeouts. I've changed the Hbase RPC timeout to 15 minutes which I can confirm frm the UI... I also changed the…
Z.xie
  • 11
  • 5
0
votes
1 answer

Node.js and npm phoenix-client package connectivity with kerberized Apache phoenix

I am trying to connect kerberized Apache phoenix with the npm jdbc package on node.js [ node.js and npm jdbc package issue with kerberized apache phoenix ], but facing lots of challenges, hence looking for other solutions; In my case npm…
nilesh1212
  • 1,561
  • 2
  • 26
  • 60
0
votes
1 answer

want to understand the query execution plan for Apache Phoenix

I want to understand the query execution plan for Phoenix. I am executing below command to get query execution plan. Command: - explain select "col1","col2", count(*) as "Count" from "tab_name" group by "col1","col2"; Explain Plan:…
Vijay_Shinde
  • 1,332
  • 2
  • 17
  • 38
0
votes
1 answer

Unable to start apache phoenix over hbase

I am unable to start apache phoenix installed over hbase. I get below error when i try to execute the py file. Please advise
Harish
  • 565
  • 1
  • 12
  • 34
0
votes
2 answers

Loading hbase table using Phoenix CsvBulkLoadTool() from jboss5.1

I am trying to load hbase table using phoenix CsvBulkLoadTool() from jboss. it's running but it's not taking configuration from hbase-site.xml kept in the WEB-INF/classes folder. when i am running through command line it's taking hbase-site.xml…
Rahul
  • 459
  • 2
  • 13
0
votes
1 answer

Error launching Phoenix on Hbase

I installed Phoenix in my system and copied phoenix-4.10.0-HBase-0.98-server.jar to the Hbase lib directory.Then I restarted Hbase. If i try to execute sqlline.py to launch phoenix Hbase it throws below error. Please Advise
Nirmal Anand
  • 307
  • 1
  • 4
  • 14
0
votes
0 answers

trying tio connect to phoenix table with pyspark and getting the following error

my commnd for reading phoenix table: sql_sc.read.format("org.apache.phoenix.spark").option("table", tablename).option("zkUrl", "10.0.11.21:2181").load() error: Traceback (most recent call last): File "/bdaas/exe/healthcare/hl7visualization.py",…
Karthik Gunapati
  • 11
  • 1
1 2 3
…
46 47