For questions about Apache Phoenix. For the Elixir web framework, use phoenix-framework.
For questions about Apache Phoenix. For the Elixir web framework, use phoenix-framework.
Questions tagged [apache-phoenix]
702 questions
0
votes
2 answers
Update Non key columns Query Pheonix JDBC
I have problem with updating values in apache phoenix . The below query is throwing JDBC exception. I am new to Pheonix JDBC and confusing with upsert query usage for updating non primary key field values.
String sql = UPSERT INTO mytable…
Kiran
- 921
- 1
- 11
- 23
0
votes
1 answer
Apache Phoenix Bulk Data Loading - Can't use table name by small letter
i have existing Phoenix table abc
i wanna Bulk Data Loading via MapReduce
And then used the following command to load the csv file
hadoop jar /root/Phoenix/apache-phoenix-4.8.0-HBase-0.98-bin/phoenix-4.8.0-HBase-0.98-client.jar…
judid
- 1
- 1
0
votes
1 answer
Create table statement using Phoenix with column family name for dynamic columns
I am beginner in using Phoenix as well as HBase.
I am unable to use UPSERT statements of phoenix with column family name for dynamic columns.
My create table statement :
CREATE TABLE TEST(
A UNSIGNED_LONG NOT NULL,
B VARCHAR NOT null,
C…
Blank
- 81
- 11
0
votes
2 answers
Apache phoenix concurrent queries failing with exception
We are trying a bunch of operations like SELECT -> store row key into a collection ->then split the collection into each worker thread -> Each thread again created connection using phoenix jdbc -> perform SELECT then depending on the result UPSERT…
hopeIsTheonlyWeapon
- 557
- 6
- 19
0
votes
2 answers
Select one row where alert type and item id are the same and also how many similar rows
I am trying to make the notification system for my project as simple as possible on the user's side.
"john brown and 4 others liked your photo"
I tried:
Select a.id, a.item_id, a.type u.f_name, u.l_name, count(a)
From alerts
Join users on a.user_id…
Cheyenne Forbes
- 491
- 1
- 5
- 15
0
votes
2 answers
Spark Streaming and Phoenix Kerberos issue
Sorry for this question as this has been raised numerous time on SO, But I am still not able to find a solution for my issue after going through each relevant post.
I am using Spark Streaming (1.6.1) with Phoenix (4.4) on Kerberos env on HDP 2.4.2…
nilesh1212
- 1,561
- 2
- 26
- 60
0
votes
2 answers
Renewing a connection to Apache Phoenix (using Kerberos) fails after exactly 10 hours
I have a Java application with possibility to make some SQL select statements from Apache Phoenix. For this i'm using a principle with a keytab to create the connection. This is the class that support the connection :
public class…
Amine CHERIFI
- 1,155
- 2
- 20
- 35
0
votes
1 answer
Apache Phoenix create view throws TableAlreadyExistException
I have created a table in Hbase using shell which contains 2 columns families. I am able to write into it using Hbase client API. I am using the phoenix JDBC driver to query data from it. I learnt that there is no one to one mapping between HBase…
AnswerSeeker
- 203
- 4
- 16
0
votes
2 answers
Phoenix connection throws error message "Failed to find any Kerberos tgt" after running for some time
I am using Phoenix to connect to secure HBase. It runs well when the client starts up. I can connect to HBase an query the data from HBase. The Phoenix JDBC connection is in the connection pool and doesn't close. But after a few hours, I can't query…
Wenyuan Chen
- 115
- 1
- 10
0
votes
1 answer
Connect to Test Hbase table via Phoenix
I wanted to know if and how can I connect to HBaseTestTable which I made using
(org.apache.hadoop.hbase.HBaseTestingUtility;) via Phoenix. I want to have a successful connection to Hbase then insert into the Test table and retrieve data from the…
Blank
- 81
- 11
0
votes
1 answer
I want to collect the data frame column values in an array list to conduct some computations, is it possible?
I am loading data from phoenix through this:
val tableDF = sqlContext.phoenixTableAsDataFrame("Hbtable", Array("ID", "distance"), conf = configuration)
and want to carry out the following computation on the column values distance:
val…
vivek
- 71
- 8
0
votes
1 answer
SparkSQL: Am I doing in right?
Here is how I use Spark-SQL in a little application I am working with.
I have two Hbase tables say t1,t2.
My input being a csv file, I parse each and every line and query(SparkSQL) the table t1. I write the output to another file.
Now I parse the…
theScalaGuy
- 27
- 4
0
votes
1 answer
SQuirreL SQL Client add aliases error
When I am add alias in SQuirreL SQL Client to connect hbase using phoenix,this is the exception log:
Unexpected Error occurred attempting to open an SQL connection.
This is the detail:
java.util.concurrent.ExecutionException:…
Dolphin
- 29,069
- 61
- 260
- 539
0
votes
1 answer
Best practice for template setup in Elm or Phoenix
I am using elm for front-end and phoenix as back-end.
What is the best practices to create template which will be inherited by all pages? SHould it be implemented in phoenix or elm.
Any advice is greatly appreciated.
Natallia
- 157
- 1
- 9
0
votes
0 answers
Hbase & spark takes more than 10 mins to read and consolidate 1 million rows out of 100 million
I am doing a performance benchmark of Hbase and Spark, and stuck in a position where Spark takes >10 mins to read and consolidate 1 million rows out of 97 million rows present. Below are the details about configurations and data.
Hardware:
Total 4…
Lokesh Kumar P
- 369
- 5
- 20