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
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,211
  • 2
  • 20
  • 40
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
  • 20,430
  • 4
  • 39
  • 67
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
  • 239
  • 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…
scoder
  • 2,451
  • 4
  • 30
  • 70
5
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") …
Eti49
  • 140
  • 11
5
votes
1 answer

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…
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
  • 2
  • 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…
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
  • 21,738
  • 2
  • 113
  • 124
5
votes
7 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
  • 350
  • 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,303
  • 5
  • 31
  • 53
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
  • 853
  • 2
  • 14
  • 24
1
2
3
46 47