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

Issue using Phoenix JDBC with Squirrel SQL

I am trying to connect Squirrel SQL to an Apache Phoenix database, but instead getting the below error: Could not find class org.apache.phoenix.jdbc.PhoenixDriver in neither the Java class path nor the Extra class path of the ARAF_Phoenix driver…
user3699367
0
votes
1 answer

Phoenix quick start doesn't work

I deployed a HBASE 1.2.2 in pseudo distribution mode and was trying to add Phoenix for Hbase 1.2+ to see if it works. I followed the installation instruction on Phoenix website http://phoenix.apache.org/installation.html, but it doesn't as Hbase…
George
  • 29
  • 1
  • 6
0
votes
1 answer

HBase Row Key Design

I'm using Hbase coupled with phoenix for interractive analytics and i'm trying to desing my hbase row key for an iot project but i'm not very sure if i'm doing it right. My Database can be represented into something like this : Client--->Project…
azelix
  • 1,257
  • 4
  • 26
  • 50
0
votes
0 answers

Spark can't connect to secure phoenix

I am running a spark program on secured cluster which creates SqlContext for creating dataframe over phoenix table. When I run my program in local mode with --master option set to local[2] my program works completely fine, however when I try to run…
userAG
  • 31
  • 4
0
votes
1 answer

How to access Phoenix table from Hbase

I am trying to access a table created through Phoenix from Hbase. I am able to read the string values , but not able to read the decimal values.For e.g., DECIMAL_PLACE_CNT has actual value of 6 but from hbase shellit shows value=\xC1\x07 How can I…
zebb
  • 3
  • 2
0
votes
2 answers

Phoenix Query Server not returning any results

I have just started using Apache Phoenix on HBase. We have a setup where Phoenix is working when invoked from within the cluster nodes (We are able to CRUD in tables cleanly). Now, we want an application running outside the network (say a system…
iamds
  • 21
  • 1
0
votes
3 answers

Combining two queries to get total count and filtered list

I have a query that gets all user ids that has logged in within the past year. Query1: SELECT user_id, user_name FROM logins WHERE login_date BETWEEN "2015-09-01" AND "2016-09-01" GROUP BY user_id; Execution time: 625ms And another query similar…
vhen
  • 105
  • 12
0
votes
1 answer

how to use phoenix transaction with jdbc client

I am using phoenix with transactions, as from phoenix.apache.org/transactions.html, I need to set phoenix.transactions.enabled=true from my client-side. But how to set that in a java jdbc client?
co2y
  • 179
  • 12
0
votes
1 answer

Can I map the TIMESTAMP corresponding to an HBase column value to a VIEW created in Apache Phoenix?

In the Apache Phoenix FAQ, we learn how to map an existing HBase table to a Phoenix view. Seperately, the Phoenix documentation describes how to create a Phoenix table with a ROW_TIMESTAMP comprising part of the primary key. I have an HBase table…
Will Hardman
  • 193
  • 1
  • 2
  • 8
0
votes
1 answer

apache phoenix join issue

when i do the query operation with "join" in my statement , i get the error information.Below are the error, environment and version details. jdk-1.7.0_79 Phoenix-4.7.0 Hbase-1.1.2 with 7 region servers. Caused by: java.sql.SQLException:…
Z.xie
  • 11
  • 5
0
votes
1 answer

Hadoop with phoenix: how to write the phoenix table object to hdfs filesystem

I have a map reduce job, which reads from hbase table using phoenix. I want the output of this job is in HDFS and then feed to another map reduce job, where I will update in to HBASE table. This is what I have tried. public class Job1Driver extends…
lima
  • 341
  • 2
  • 11
0
votes
3 answers

Phoenix 4.8 Issue

I have Phoenix 4.8 and hbase 1.2; I have copied jars : phoenix-core-4.8.0-HBase-1.2.jar and phoenix-4.8.0-HBase-1.2-client.jar in the hbase/lib folder. On starting .sqlline.py ; I am getting following error : Error: ERROR 2007 (INT09): Outdated…
Manju
  • 21
  • 4
0
votes
1 answer

Is it possible to use imported classes in Apache Phoenix UDFs?

I wrote some UDFs for Phoenix, and outsourced some functions in other classes, because they are used in multiple UDFs. Now if I register a function and execute it, I get a ClassNotFoundException for the helper class which is imported into the UDF…
olkoza
  • 715
  • 2
  • 17
  • 35
0
votes
1 answer

can not connect to phoenix using python phoenixdb library

I have Phoenix which is integrated with HBase. I am trying to access phoenix from python code using pythondb library, and I have started the QueryServer using bin/queryserver.py start But after the connect statement I get the following…
Aboulfouz
  • 98
  • 8
0
votes
1 answer

Phoenix JDBC connection time is too long

I'm working on phoenix-4.7.0 on HBase-0.98 and trying to write java source to decide whether I can use phoenix as a SQL-SKIN or not. I set phoenix-4.7.0-HBase-0.98-client.jar as $CLASSPATH and It works fine but It takes a few seconds to finish…
KIM
  • 1,204
  • 2
  • 17
  • 33
1 2 3
…
46 47