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

Connecting to Spark using Apache Phoenix Spark plugin and running custom SQL queries

Could someone tell how to connect to Spark using Phoenix Spark connector rather than using Phoenix as a JDBC data source (This works if used as a JDBC source but performance is an issue https://phoenix.apache.org/phoenix_spark.html). This is my…
Vikash Raja Samuel Selvin
  • 159
  • 1
  • 1
  • 14
0
votes
0 answers

Hbase cluster running Phoenix is slow using jdbc and python phoenixdb

I have a cluster setup running HBase and a phoenix queryserver. Currently my cluster contains a master node and 3 slaves. The table I am connecting to consists of 124 columns and a total of 16 million rows. A simple COUNT(*) or DISTINCT "value"…
Zeliax
  • 4,987
  • 10
  • 51
  • 79
0
votes
1 answer

Unable to connect to Phoenix using JDBC

I have a Hadoop Cluster set up with HBase and Phoenix and I'm trying to connect to Phoenix using JDBC, but I am sort of unable to get a successful connection. I want to use JDBC to connect using Python 3.x but as for simple test purposes I set up a…
Zeliax
  • 4,987
  • 10
  • 51
  • 79
0
votes
1 answer

Compilation error function PhoenixSwagger.Plug.SwaggerUI.init/1 is undefined Elixir v1.4

Using PhoenixSwagger leads to compilation error using phoenix swagger # mix file {:phoenix_swagger, "~> 0.4.0"} # router.ex use PhoenixSwagger .. scope "/api/swagger" do forward "/", PhoenixSwagger.Plug.SwaggerUI, otp_app: :http, swagger_file:…
tastebuds
  • 1,026
  • 2
  • 10
  • 15
0
votes
0 answers

HBase Secondary Indexing performance (BIGSQL VS PHOENIX)

Hi in my workplace we are using IBM BigInsights,we create secondary indexes on hbase table using BIGSQL, if the secondary indexes are present the row ingestion speed drops from 3000 rows /sec to 200 rows/sec. How is the performance of phoenix in…
siva krishna
  • 23
  • 5
0
votes
0 answers

Error while saving spark Dataframe in hbase using phoenix in SparkR

I am trying to save a spark dataframe into hbase using phoenix. I am able to read from the database but am facing an issue while trying to write into it. Reading Data from test1 df_output <-…
Stanley
  • 31
  • 2
0
votes
1 answer

python and phoenixdb on Ubuntu (or Windows). How to?

I have created a python script connecting to a Phoenix HBase to analyze some data. I want to set this script up on crontab on a ubuntu server that I have running. The script is perfectly able to run on my Windows 10 machine. But when I try to use…
Zeliax
  • 4,987
  • 10
  • 51
  • 79
0
votes
0 answers

JDBC Prepared statement Timestamp issues

I am working on requirement where I need to query Hbase database using Phoenix JDBC driver. The exact query look like String sql="SELECT * FROM Part_Data WHERE server = ? AND process = ? AND event_utc <= ? ORDER BY event_utc DESC LIMIT 3"; …
Rohith Kammula
  • 31
  • 1
  • 6
0
votes
1 answer

Python, phoenixdb - not getting a row (but not getting any errors either)

I have an Apache Phoenix DB set up and I'm trying to query it using Python with the PhoenixDb plugin. I have a table with the following…
Zeliax
  • 4,987
  • 10
  • 51
  • 79
0
votes
1 answer

Pyspark: pushing filter by date against apache phoenix

I am trying to filter by date in apache phoenix from pyspark. The column in phoenix is created as Date and the filter is a datetime. When I use explain I see spark doesn't push the filter to phoenix. I have tried a lot of combinations without…
Pablo Castilla
  • 2,723
  • 2
  • 28
  • 33
0
votes
0 answers

Getting errors while I'm connecting to Hbase from Spark using Amazon EMR?

I'm trying to connect Hbase tables from Spark using Amazon EMR. I'm using the below versions of the drivers. Hbase : 1.1.2.2.3.4.0-3485 Phoenix driver : 4.2.0.2.2.0.0-2041 When i'm running my fat jar on EMR getting below errors. I tried to resolve…
knowledge_seeker
  • 362
  • 3
  • 20
0
votes
1 answer

Phoenix Build fail. Cannot find Symbol. Phoenix 4.8.2 Hbase-1.2 cdh 5.9.1

I'm installing Apache Phoenix 4.8.2-Hbase-1.2 over my Cloudera's Hadoop and Hbase installation (i.e both are installed through cdh 5.9.1) Followed these instructions to build Phoenix over it: Using Phoenix with Cloudera Hbase (installed from…
whitewalker
  • 433
  • 2
  • 6
  • 13
0
votes
0 answers

wxPython Phoneix GUI blocked after call to MessageDialog ShowModal

During the execution of my programme this function is called several times, but it only works the first time that I execute it. The second time that the function is called the GUI is blocked at the ShowModal call and the execution of the script…
Bobbick
  • 255
  • 3
  • 10
0
votes
2 answers

spark connecting to Phoenix NoSuchMethod Exception

I am trying to connect to Phoenix through Spark/Scala to read and write data as a DataFrame. I am following the example on GitHub however when I try the very first example Load as a DataFrame using the Data Source API I get the below exception.…
Explorer
  • 1,491
  • 4
  • 26
  • 67
0
votes
1 answer

Phoenix "org.apache.phoenix.spark.DefaultSource" error

I am new to phoenix, I am trying to load hbase table into Phoenix. When I try to load Phoenix, I am getting below error. java.lang.ClassNotFoundException: org.apache.phoenix.spark.DefaultSource My code: package com.vas.reports import…
ratnamohan b
  • 31
  • 1
  • 5
1 2 3
…
46 47