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

Unable to connect to web socket in Phoenix: Ignoring unmatched topic. But I think it matches

I'm new to Phoenix and web sockets. I'm trying to create an app with Web Sockets, but Phoenix says Ignoring unmatched topic "analysis:dn-ds.axin2" in Protsci.UserSocket. I think I have the appropriate handlers for this kind of topic, so I do not…
Maxim Krabov
  • 591
  • 4
  • 16
6
votes
2 answers

Phoenix doesn't display negative integer values correctly

I am creating a HBASE table with a value of integer -17678. But when i retrieve it from pheonix it gives me a different positive value. RowKey is a composite rowkey and there is no problem with rowkey. Hbase insertion: public class test { public…
Vignesh I
  • 2,062
  • 2
  • 15
  • 39
6
votes
1 answer

How to debug something that works under Java 7 but not under Java 8

I have a project with a unit test that works under Java 7, but not under Java 8. Is there a good way to investigate such things? (I'm sure that the test is correct; this suggests that there's a subtle bug in the implementation.) Really I suppose…
chiastic-security
  • 19,689
  • 3
  • 33
  • 62
6
votes
2 answers

Is it possible to write a hibernate dialect for Apache Phoenix?

i would like to write an hibernate dialect for Apache Phoenix. The huge problem is that the keyword of an insert statement is "Upsert" instead of "Insert". This keyword is declared at org.hibernate.sql.Insert. Is there a possibility to write an…
nickel671
  • 61
  • 2
5
votes
0 answers

Simba Phoenix ODBC driver Kerberos

I have configured Phoenix Query server for HBase datasource with kerberos authentication. When trying to connect with query server using Simba Phoenix ODBC driver getting HTTP Request/Response error with Authentication type as kerberos. Error Msg:…
Karthik Sridhar
  • 219
  • 1
  • 6
5
votes
0 answers

Zeppelin Internal error processing create Interpreter

I tried to install new zeppelin i.e 0.8.0 version, I followed this link to install zeppelin . Since I wanted phoenix interpreter, I added interpreter with the help of guide given in here. When I run the the below paragraph I got the below error…
kcoder
  • 1,701
  • 2
  • 18
  • 39
5
votes
0 answers

How to save a dataframe into HBase?

I have a df with a schema, also create a table in HBase with phoenix. What i want is to save this df to HBase using spark. I have tried the descriptions in the following link and run the spark-shell with phoenix plugin dependencies. spark-shell…
Saygın Doğu
  • 265
  • 3
  • 15
5
votes
1 answer

PHOENIX SPARK - Load Table as DataFrame

I have created a DataFrame from a HBase Table (PHOENIX) which has 500 million rows. From the DataFrame I created an RDD of JavaBean and use it for joining with data from a file. Map phoenixInfoMap = new HashMap
Mohan
  • 282
  • 1
  • 16
5
votes
2 answers

apache phoenix Join query performance

I started using phoenix couple of months back. Below are the environment and version details. Hadoop – Cloudera CDH 5.4.7-1. Phoenix – 4.3 – Phoenix which comes as parcels on CDH5.4.7-1. HBase version – HBase 1.0.0 JDK – 1.7.0_67 1 Master and 3…
Shivamohan M P
  • 51
  • 1
  • 5
5
votes
1 answer

Column family with Apache Phoenix

I have create the following table: CREATE TABLE IF NOT EXISTS "events" ( "product.name" VARCHAR(32), "event.name" VARCHAR(32), "event.uuid" VARCHAR(32), CONSTRAINT pk PRIMARY KEY ("event.uuid") ) Inserting an event: upsert into "events"…
Thomas Decaux
  • 18,451
  • 2
  • 83
  • 95
5
votes
6 answers

org.apache.hadoop.hbase.TableNotFoundException: SYSTEM.CATALOG exception with phoenix 4.5.2

I've been trying to integrate Phoenix 4.5.2 to my existing hadoop cluster. Hadoop Version : 2.7.1 HBase Version : 1.1.2 When I try to create table from my phoenix client I'm getting following exception. But I'm able to create table successfully…
Naresh Reddy
  • 320
  • 1
  • 3
  • 7
5
votes
1 answer

Squirrel Client Connecting to Phoenix - Timeout Exception

I am trying to connect to Phoenix via Squirrel client. I am receiving the following logs in the Squirrel logs. The logs suggests that the ClientConnection to zooperkeeper is established however it fails when a SQLClient Connection is being…
Rashmi Mahale
  • 81
  • 1
  • 6
5
votes
2 answers

phoenix map existing HBase table

I have a Hbase table "http_access_log", now i want to use Apache phoenix for SQL on it. Should I create phoenix view or table to map hbase table? And if the hbase table is updated by the hbase api, will the phoenix view or table be updated?
robertc
  • 51
  • 1
  • 2
5
votes
2 answers

How do I change data type of column in Apache Phoenix without losing HBase data?

I have an HBase installation with a bunch of existing tables, with a bunch of data in them (which I would like not to be deleted). I recently came across using Apache Phoenix to be able to query HBase data with a SQL-like syntax, and so far it is…
Matt
  • 3,077
  • 4
  • 26
  • 50
5
votes
2 answers

Apache Phoenix vs Hbase Native API

I am using Apache Phoenix for simplifying my data retrieval/update operations on Hbase. But I would like to know from the performance point of view which one would be better? Phoenix or Custom wrapper using Hbase Native API? Or do we have any other…
Ashok Krishnamoorthy
  • 775
  • 1
  • 11
  • 17
1
2
3
…
56 57