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
2 answers

Apache phoenix not getting started

I have installed HBase 1.1.3 on multi cluster configuration and wanted to run Apache phoenix over it. I download phoenix 4.7, installed it as per the guidelines mentioned here: https://phoenix.apache.org/installation.html But when i am running the…
Gagan
  • 1,775
  • 5
  • 31
  • 59
0
votes
2 answers

table are created in hbase shell are not detected in phoenix shell

When I create table by phoenix shell it is detected in hbase shell by command list, but the same is not identified in Phoenix. Phoenix just detects tables that are created in phoenix shell in addition HBase default table. How can I fix this problem?
ahoora
  • 19
  • 4
0
votes
0 answers

apache phoenix query using dynamic columns returns no record

I have a phoenix table over existing HBase table created like: CREATE TABLE "t" ("rowkey" VARCHAR PRIMARY KEY) table t is an existing HBase table with several other columns all in one column family cf. Now, when I run the following query on…
A Z
  • 1
0
votes
1 answer

Single column families in phoenix

I am recently learning apache phoenix on top of hbase. I am creating table in phoenix. In this I found that phoenix is not creating multiple column families instead it is using single column family with name '0'. Does this hamper the performance of…
sdk
  • 178
  • 2
  • 19
0
votes
2 answers

error in running phoenix example

I've integrated my hadoop2 and hbase0.98 with phoenix and by typing command sqlline.py localhost phoenix shell starts, but when I try to run apache phoenix example by this command : psql.py /usr/local/phoenix/examples/WEB_STAT.sql…
ahoora
  • 19
  • 4
0
votes
3 answers

Disabling HBase Block Cache

I am using apache hbase (version 1.0.0) and phoenix (version 4.6) deployed through cloudera. Since my aggregations with group by query is slow, I want to try out disabling the block cache for a particular hbase table. I tried a couple of approaches…
Andy Dufresne
  • 6,022
  • 7
  • 63
  • 113
0
votes
1 answer

apache phoenix DoNotRetryIOException

when i run the sql to create table, like this: CREATE TABLE FM_DAY( APPID VARCHAR NOT NULL, CREATETIME VARCHAR NOT NULL, PLATFORM VARCHAR NOT NULL, USERCOUNT UNSIGNED_LONG, LONGCOUNT UNSIGNED_LONG, …
Orange
  • 1
  • 2
0
votes
1 answer

Apache Phoenix + Pentaho Mondrian wrong join order

I am using Apache Phoenix 4.5.2 from Cloudera labs distribution, which is installed over CDH 5.4 cluster. Now I'm trying to use it from Pentaho BA 5.4 server with embedded Mondrian and SAIKU Plugin installed. I'm planning to use is as aggregator for…
Boris Treukhov
  • 17,493
  • 9
  • 70
  • 91
0
votes
1 answer

What is the correct way to "pool" the Phoenix Query Server connections

We are using Azure and Phoenix to write into an HBase cluster. There are two drivers: one big one and a thin client. The thin client uses Json over HTTP to interact with the database. When we create a new connection each save we can save at…
markthegrea
  • 3,731
  • 7
  • 55
  • 78
0
votes
2 answers

When I use jdbc and phoenix to query data from hbase,the "resultset.first()" throw exception

the code like this: the exception like this: java.sql.SQLFeatureNotSupportedException at com.salesforce.phoenix.jdbc.PhoenixResultSet.first(PhoenixResultSet.java:173)
WholeStack
  • 23
  • 8
0
votes
2 answers

Insert multiple rows with one request using phoenix query server on Hbase

I am looking to combine multiple upsert requests into one request and pass it to the phoenix query server. I am sending the following json to upsert one record POST https://tishihdiphoenix.azurehdinsight.net/hbasephoenix/ HTTP/1.1 request: { …
Aditya Goparaju
  • 1
  • 3
0
votes
2 answers

Can I use phoenix to achieve the feature like SQL's duplicate key?

I want to use phoenix to insert data into Hbase like this: INSERT INTO mytable (col1, col2) VALUES (?, ?) ON DUPLICATE KEY UPDATE col2 = col2 + ? Is there any method to achieve this in phoenix?
cxco
  • 143
  • 2
  • 13
0
votes
1 answer

Creating a Phoenix index in Hortonworks Sandbox doesn't work

I followed the documentation, and created in Phoenix 4.2: CREATE VIEW "t20" ( pk VARCHAR PRIMARY KEY, "f2"."name" VARCHAR ); Then created an index: create index idx on "t20" ("name"); (Quoting or unquoting gives the same result) And getting: ERROR…
matthieu lieber
  • 662
  • 1
  • 17
  • 30
0
votes
2 answers

Apache Phoenix - Insert multiple rows with one upsert statement

I am working with Apache Phoenix and I am trying to generate a bunch of test data so I can measure performance. I was wondering if there is a way to insert multiple rows using one UPSERT statement. I want a Phoenix equivalent to this Oracle SQL…
Soto
  • 611
  • 6
  • 19
0
votes
0 answers

Not finding my HBase table columns in my Phoenix table

Created my HBase table: hbase(main):091:0> create 't20', {NAME => 'f2', VERSIONS => 5} put data: hbase(main):092:0> put 't20' , '1112', 'f2:name', 'aash2' scan: scan 't20' ROW COLUMN+CELL …
matthieu lieber
  • 662
  • 1
  • 17
  • 30
1 2 3
…
46 47