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

parsing of where clause in phoenix

I want to know the complete lifecycle of where clause condition in phoenix. How does the value of where condition get parse from different classes and intermediate value . Where is exactly the where clause logic and scan object reside in…
shubham
  • 1
  • 2
0
votes
2 answers

phoenix connection namenode ha and hbase failed

some base info follow: Hadoop2.7.1 and NameNode HA Enable Hbase0.98.12 phoenix-4.6.0-HBase-0.98 execute sqlline.py localhost is error execute sqlline.py localhost:nameservices/hbase is error phoenix don't support NameNode is HA Hadoop clusters…
Qin Dong Liang
  • 415
  • 3
  • 12
0
votes
1 answer

Unable to save to HBase using Pheonix from spark

I am trying sample code to save data to HBase from spark DataFrame. I am not sure where i went wrong but the code is not working for me. Below is the code, that i tried. I am able to get the RDD for existing table, but could not save it. I tried…
Srini
  • 3,334
  • 6
  • 29
  • 64
0
votes
1 answer

MapReduce with phoenix : org.apache.hadoop.io.LongWritable cannot be cast to org.apache.hadoop.io.NullWritable

I am trying to insert values into a table ("mea_interval") from data collected in another table ("mea_data"). The idea is not unique, it identifies a datatype. I use MeasureWritable class to read and write to the database, it implements DBWritable…
Lucie M
  • 13
  • 2
0
votes
2 answers

Phoenix create index meet exception

When I want to create index on a big hbase table with more than one hundred million rows in the sqlline cmd, I got an exception after a few minutes. I don't known how to resovle this problem. My env is: hbase(main):001:0> version 1.0.0-cdh5.4.2,…
CrazyPig
  • 137
  • 12
0
votes
1 answer

Apache Phoenix csvbulkloadTool failed

I am using the following Linux command: hadoop jar phoenix-4.6.0-HBase-0.98-client.jar org.apache.phoenix.mapreduce.CsvBulkLoadTool --table TT --input /tmp/text.csv This command works successfully, but no data from csv file is loaded in hbase…
paul
  • 11
  • 4
0
votes
1 answer

Timestamp format for phoenix upsert into hbase?

I am writing upsert script for phoenix to make the records in hbase. CREATE TABLE IF NOT EXISTS temp.table ( id bigint(20), created_at timestamp, updated_at timestamp, CONSTRAINT pk PRIMARY KEY (id) ); And when I use upsert script upsert into…
Pradeep Kr Kaushal
  • 1,506
  • 1
  • 16
  • 29
0
votes
0 answers

Apache Phoenix check configuration or tuning are valid

Recently i configure/tuning based on this link so how can i make sure that my tuning are valid and running? is there a page or a code that can be proof of my tuning? Thank before.
Galih Tias
  • 101
  • 1
  • 4
0
votes
2 answers

PySpark HBase/Phoenix integration

I'm supposed to read Phoenix data into pyspark. edit: I'm using Spark HBase converters: Here is a code snippet: port="2181" host="zookeperserver" keyConv =…
Ranic
  • 443
  • 3
  • 10
0
votes
1 answer

Apache Phoenix Installation not done properly

We are trying to install Phoenix 4.4.0 on HBase 1.0.0-cdh5.4.4 (CDH5.5.5 four nodes cluster) via this installation document: Phoenix installation Based on that we copied our phoenix-server-4.4.0-HBase-1.0.jar to hbase libs on each region server and…
josele
  • 79
  • 1
  • 9
0
votes
2 answers

Can't run a python script

I am trying to run the performance.py script that comes with the Phoenix Apache open source project. Per instructions (I am new to python), I execute: performance.py localhost 999 I get this error: Phoenix Performance Evaluation Script…
AngryHacker
  • 59,598
  • 102
  • 325
  • 594
0
votes
1 answer

How do I see the actual Map Reduce job in Hadoop from beyond all abstractions?

I have a Hadoop Cluster. On top of that is HBase. On top of that is Phoenix. When I execute SELECT * FROM TEST LIMIT 1000; from Phoenix... how do I actually see what job was sent to hadoop?
AngryHacker
  • 59,598
  • 102
  • 325
  • 594
0
votes
1 answer

spring apache phoenix integration on Hbase steps

I am new to Apache phoenix .How to use Apache phoenix with spring.what are the steps to connect to spring and Apache phoenix.how to configure jdbc Template with phoenix connection details.
kartik
  • 71
  • 1
  • 8
0
votes
1 answer

How Apache Phoenix secondary indexing works

How secondary index works with Phoenix. I have an HBASE database setup, which is updated via direct insertion in HBASE and not via Phoenix insert queries. But all the select will be done via Phoenix select queries. Will Phoenix secondary indexes…
Saurabh
  • 71,488
  • 40
  • 181
  • 244
0
votes
1 answer

Validation query in Apache Phoenix

Is it possible to write a sensible validation query in Apache Phoenix? I want something that will send a trivial query to the database, and return a small and predictable result, with no assumptions as to what is already stored in the database. It…
chiastic-security
  • 20,430
  • 4
  • 39
  • 67