Stack Overflow
Stack Overflow

Questions tagged [phoenix]

Use this tag for questions about Apache Phoenix, an open source project in the Hadoop ecosystem which provides an SQL layer on top of HBase (a non-relational database). For questions about the Phoenix Framework - an Elixir web framework for building HTML5 apps, APIs and distributed applications - use the tag [phoenix-framework].

Apache Phoenix is a SQL skin over HBase delivered as a client-embedded JDBC driver targeting low latency queries over HBase data. Apache Phoenix takes your SQL query, compiles it into a series of HBase scans, and orchestrates the running of those scans to produce regular JDBC result sets. The table metadata is stored in an HBase table and versioned, such that snapshot queries over prior versions will automatically use the correct schema. Direct use of the HBase API, along with coprocessors and custom filters, results in performance on the order of milliseconds for small queries, or seconds for tens of millions of rows.

References

Related Tags

845 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…
chandresh_cool
  • 11,444
  • 2
  • 25
  • 44
4
votes
1 answer

Caching on Heroku CI

I am setting up Heroku CI with Elixir Phoenix buildpack. I want to start using Dialyzer. Diazlyer is a static analysis tool that before the first run takes at least a couple of minutes to create a "persistent lookup table" (PLT) of types from…
tkowal
  • 8,659
  • 1
  • 20
  • 42
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
  • 781
  • 6
  • 23
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
  • 805
  • 8
  • 16
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,045
  • 11
  • 26
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…
BASS KARAN
  • 181
  • 6
4
votes
1 answer

Joining Two Datasets with Predicate Pushdown

I have a Dataset that i created from a RDD and try to join it with another Dataset which is created from my Phoenix Table: val dfToJoin = sparkSession.createDataset(rddToJoin) val tableDf = sparkSession .read .option("table", "table") …
Etibu
  • 93
  • 9
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,327
  • 2
  • 15
  • 45
4
votes
2 answers

How to enable the debug flag of Elm 0.18 in phoenix/elixir

I am starting a new project trying to use both the Phoenix framework and Elm. I have the project setup properly, but I was wanting to enable the debugger that was released in Elm 0.18 in my project. Does anyone know how to enable the --debug flag…
Verlon Smith
  • 43
  • 4
4
votes
0 answers

How to set up a postfix dummy smtp server in Travis-CI for use with a Phoenix app?

I am working on a Elixir/Phoenix app that uses Bamboo to send email using a server at 127.0.0.1:25. My TravisCI builds fail because of the lack of a SMTP server in the TravisCI environment. How can I set up the travis-yaml to install a postfix…
Chris Freeze
  • 43
  • 4
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,639
  • 2
  • 17
  • 39
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
  • 8
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,154
  • 15
  • 32
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:…
Jeroen Vlek
  • 158
  • 2
  • 11
1 2
3
…
56 57