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
4
votes
1 answer

Apache Phoenix - GCP Data Proc

I am doing a POC on Google Cloud Dataproc along with HBase as one of the component. I created cluster and was able to get the cluster running along with the HBase service. I can list and create tables via shell. I want to use the Apache Phoenix as…
4
votes
1 answer

How to drop a view in Phoenix

I created a Phoenix view company1:USERS for an existing HBase table. Namespace is company1 and table name is USERS. I don't have Phoenix table mapped to the existing Hbase table. CREATE VIEW "company1:USERS" ( pk VARCHAR PRIMARY KEY, CF.USERNAME…
Julius Delfino
  • 991
  • 10
  • 27
4
votes
4 answers

multiple insert into a table using Apache Spark

I am working on a project and i am stuck on following scenario. I have a table: superMerge(id, name, salary) and I have 2 other tables: table1 and table2 all the tables ( table1, table2 and superMerge) has same structure. Now, my challenge is to…
GKV
  • 864
  • 1
  • 12
  • 25
4
votes
2 answers

java.lang.NoClassDefFoundError: org/apache/spark/sql/DataFrame

I am running my Spark code to save data to HBase in Amazon EMR 5.8.0 which has Spark 2.2.0 installed. Running in IntelliJ, it works fine but in EMR Cluster it is throwing me this error: java.lang.NoClassDefFoundError:…
abstractKarshit
  • 1,355
  • 2
  • 16
  • 34
4
votes
0 answers

Apache Phoenix - How can start the query server and thin client on Kerberos cluster

I have recently spent several days trying to run the phoenix thin (queryserver.py and sqlline-thin.py) and thick via zookeeper to secure cluster.But, I could not able to start or connect the phoenix service on secure cluster. Faced Below issues on…
4
votes
1 answer

node.js and npm jdbc package issue with kerberized apache phoenix

I am using nodejs and the npm jdbc package to connect to kerberized Apache phoenix on hortonworks, I am able to connect to non kerberized phoenix with nodejs and jdbc package, but facing below Kerberos authentication error with kerberized phoenix.…
nilesh1212
  • 1,561
  • 2
  • 26
  • 60
4
votes
1 answer

How to use java api to send hbase shell command directly like jdbc?

How to use java api to send hbase shell command directly like jdbc? public static void main(String args[]) { // get Connection to connect hbase Connection conn = ....; // hbase shell command String cmd = "get 't1','r1'"; …
Guo
  • 1,761
  • 2
  • 22
  • 45
4
votes
3 answers

Java objects to Hbase

I'm currently using KITE API + AVRO to handle java objects to HBase. But due to various problems I'm looking for an alternative. I've been reading about: Phoenix Native Hbase Api. But there is more an alternative? . The idea is to save and to…
Gui Pinto
  • 57
  • 9
4
votes
1 answer

Jar not found in hbase classpath on a Cloudera 4.7.0 cluster

I am in the process of upgrading the version of Apache Phoenix used on a CDH 4.7.0 cluster running hbase version 0.94.15-cdh-4.7.0. My goal is to migrate us from Phoenix version 3.1.0 to 3.3.1, but my join statements begin to fail when I upgrade to…
Acerebral
  • 51
  • 4
4
votes
1 answer

BulkLoading to Phoenix using Spark

I was trying to code some utilities to bulk load data through HFiles from Spark RDDs. I was taking the pattern of CSVBulkLoadTool from phoenix. I managed to generate some HFiles and load them into HBase, but i can't see the rows using sqlline(e.g…
Dawid Wysakowicz
  • 3,402
  • 17
  • 33
4
votes
3 answers

Apache Phoenix (4.3.1 and 4.4.0-HBase-0.98) on Spark 1.3.1 ClassNotFoundException

I'm trying to connect to Phoenix via Spark and I keep getting the following exception when opening a connection via the JDBC driver (cut for brevity, full stacktrace below): Caused by: java.lang.ClassNotFoundException:…
4
votes
0 answers

Java Apache Phoenix 4.1.0/4.2.2. Not able to create connection

I am not able to connect to HBase through Apache phoenix driver. Env info: hadoop-2.6.0. hbase-0.98.9-hadoop2. phoenix-4.1.0-server-hadoop2(Kept on all region servers). phoenix-4.1.0-client-hadoop2(Using this jar to create a jdbc connection). Java…
Abinash
  • 103
  • 11
4
votes
4 answers

Can not connect to hbase via phoenix

I am trying to connect hbase via phoenix: First, I added phoenix-2.jar to hbase lib directory. Then restart region server and then create a project in netbeans and add the phoenic-2-client.jar to classpath of the project. Then added below lines into…
Asma
  • 117
  • 1
  • 5
  • 14
3
votes
0 answers

Apache Phoenix: hbase-site.xml updated on server and client, but changes not reflected

We are trying to update the hbase.rpc.timeout setting on our Apache Phoenix cluster, as we are having larger queries (creating indices or querying on non-indexed values) time out. We updated the hbase-site.xml file with the new value…
Steven
  • 824
  • 1
  • 8
  • 23
3
votes
0 answers

How to fix 'No symbol could be loaded from org.apache.hbase.classification.InterfaceAudience'?

I'm trying to prepare a DataFrame to be stored in HFile format on HBase using Apache Spark. I'm using Spark 2.1.0, Scala 2.11 and HBase 1.1.2 Here is my code: val df = createDataframeFromRow(Row("mlk", "kpo", "opi"), "a b c") val cols =…
1 2
3
46 47