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

phoenix view issue on top of hbase table

I am using Hbase version 2.0.2 and phoenix V5.0.0. I have an HBase table on top of that We have created Phoenix view, using the below steps hbase(main):007:0> create 'phownix_test','details' hbase(main):008:0> put…
satish pujara
  • 219
  • 1
  • 11
2
votes
2 answers

How can I check the version of Apache Phoenix from its command line interface?

How can I check the version of Apache Phoenix from its command line? I tried googling for this info but I don't find anything useful. But I guess there should be some command (or say SELECT statement) to do this.
peter.petrov
  • 38,363
  • 16
  • 94
  • 159
2
votes
0 answers

can not connect to phoenix with python phoenixdb

I'm trying to connect to phoenix using python plugin 'phoenixdb'. I'm connecting from a server on the same network with phoenix machine. Here is the code I am using import phoenixdb import phoenixdb.cursor database_url =…
Borchaniz
  • 56
  • 3
2
votes
0 answers

How to identify the line in my csv file causing my bulk load map reduce job to fail in apache phoenix

I'm trying to load a csv file stored on hdfs, with about 140 billions lines, with apache phoenix bulk load tool. export HADOOP_CLASSPATH=$HADOOP_CLASSPATH:/etc/hbase/conf:/etc/hadoop/conf export…
cmatic
  • 51
  • 6
2
votes
1 answer

How to send a DELETE query to HBase via Spark Job

I have this use case for an automated SparkSQL Job where I want to do this : Read a table (let's call it table1) from Phoenix using Spark and gather in a DataFrame (let's call it df1) all the negative values that are found Then I want to delete…
Jules L
  • 133
  • 1
  • 7
2
votes
1 answer

Upsert to Phoenix table in Apache Spark

Looking to find if anybody got through a way to perform upserts (append / update / partial inserts/update) on Phoenix using Apache Spark. I could see as per Phoenix documentation save SaveMode.Overwrite is only supported - which is overwrite with…
Nizam
  • 77
  • 2
  • 11
2
votes
1 answer

Phoenix BIOS skips MBR code, what is the ACTUAL BIOS standard?

I want to learn assembler to use the ultra-minimum bare code to get any x86 compatible machine running to display a hardcoded text on the screen on power on. I care about full compatibility with x86/IBM machines. I followed tutorials on simple…
Antonio de las Carreras
  • 23
  • 5
2
votes
1 answer

Apache Phoenix illegal data exception

I am having problems writing data from HBase and reading it with Phoenix. These are the steps to reproduce the problem: Create a table using Phoenix. CREATE TABLE test ( id varchar not null, t1.a unsigned_int, t1.b varchar …
Óscar Andreu
  • 1,630
  • 13
  • 32
2
votes
1 answer

phoenix and hive ETL on Hbase

Is phoenix sutible for ETL and aggregation? I am trying to do some ETL on my data. Right now I am using hbase to store my data(footprint on our website). I need to do some aggregations on this data, such as page view on each url ...etc. From my…
I-PING Ou
  • 497
  • 2
  • 6
  • 18
2
votes
0 answers

Apache Phoenix unable to create schema

I am using Apache Phoenix and trying to create schema. Following are the versions used (psuedo-distributed installation) Hadoop - 2.6.4 Hbase - 1.1.2 Phoenix - 4.7.0 Sqlline - 1.1.8 Zookeper- 3.4.6 (Hbase default/ managed) I am ale to create…
Ekansh Rastogi
  • 2,418
  • 2
  • 14
  • 23
2
votes
2 answers

How to get HBase IP address for Phoenix URL

I can ssh to the Hadoop Cluster and can run the hbase command. But I need to connect using the Phoenix JDBC driver which needs the IP address of the HBase server. I tried the IP address I used for the cluster with no luck. This is probably just a…
swdev
  • 2,941
  • 2
  • 25
  • 37
2
votes
0 answers

Using HBase API to filter and decode data stored using Phoenix API

Here's a short description of the code I am writing right now: We are using Apache Hbase API to store data in Hbase Database. The schema is made up of attributes of various data types like date, float, varchar, char, etc... Now a requirement has…
Parth
  • 2,682
  • 1
  • 20
  • 39
2
votes
0 answers

python apache phoenix jdbc connection

I'm attempting to connect to Phoenix-Hbase via JDBC. Actually I already have a Phoenix connection through DBeaver and I'm trying to replicate it in python. I tried: import jaydebeapi conn = jaydebeapi.connect("org.apache.phoenix.jdbc.PhoenixDriver",…
Ignus
  • 139
  • 1
  • 8
2
votes
0 answers

How concatenate column varchar values in group by?

I want to do a select where for one column, I concatenate the values. For example, if I have the rows: ID NAME Friend 1 Joe Fred 2 Jeff Fred 3 Joe Jack 4 Joe Sally And I grouped by name,…
Don Rhummy
  • 24,730
  • 42
  • 175
  • 330
2
votes
1 answer

Spark and secured phoenix not working on yarn

I am trying to connect to secured phoenix through spark in yarn using JDBC, and i can see on the logs, it is connecting successfully: JDBC URL:…
Azel
  • 345
  • 4
  • 15
1 2 3
…
46 47