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
0 answers

hbase-indexer+Phoenix: hbase replication not working?

I have a cluster with HBASE+Phoenix. I've installed SOLR on it. Now I'm trying to set up hbase replication for the cluster, following this…
Dmitry Zuev
  • 142
  • 7
2
votes
1 answer

How to add three column which are integer in spark sql aggregation

I have came across one issue is Spark sql aggregation. I have one dataframe from which I'm loading records from apache phoenix. val df = sqlContext.phoenixTableAsDataFrame( Metadata.tables(A.Test), Seq("ID", "date", "col1", "col2","col3"), …
Nikhil Tiwari
  • 77
  • 7
2
votes
0 answers

Write pyspark DataFrame into phoenix

Here is my code to write my DataFrame df into the phoenix. df.write \ .format("org.apache.phoenix.spark") \ .mode("overwrite") \ .option("table", "TABLETEST") \ .option("zkUrl", "10.10.10.151:2181") \ .save() On running the code, It shows…
Shekhar Koirala
  • 176
  • 3
  • 10
2
votes
0 answers

insert data from pandas dataframe to phoenix table

I have a panda DataFrame i can iterate it over the row by for index, row in df.iterrows(): similarly, i can create table in phoenix by database_url = 'http://my_ip/' conn = phoenixdb.connect(database_url, autocommit=True) cursor =…
Shekhar Koirala
  • 176
  • 3
  • 10
2
votes
0 answers

Phoenix Dynamic Columns in Spark Dataframe API

I'm trying to use Phoenix to fill a HBase table with dynamic content. Therefore I did some experiments with dynamic columns (https://phoenix.apache.org/dynamic_columns.html) in the sqlline tool. E.g. I run the following queries successively: CREATE…
D. Müller
  • 3,336
  • 4
  • 36
  • 84
2
votes
1 answer

Spring Boot project in IntelliJ IDEA stops working after reboot

This is probably a newbie question, but I am not able to sort things out. I've created a Spring Boot JAR-based Maven project using the Spring Initializr interface in IntelliJ IDEA. Its dependencies on Web and JDBC; an embedded instance of Tomcat is…
Emanuele Cipolla
  • 301
  • 3
  • 16
2
votes
0 answers

Connect to Phoenix Hbase deployed as a docker image through SquirrelClient Remotely

I've deployed Hbase(Standalone), Zookeeper and Phoenix as a docker image in a virtual host. The image started successfully without any issues. Also after some changes in the config file, I could connect to the Hbase using Phoenix by ./sqlline.py…
Praveen Kumar JV
  • 21
  • 2
2
votes
2 answers

Unable to insert a row in Phoenix using a PreparedStatement

I am using phoenix-4.7.0-HBase-1.1-bin. I am trying to insert a row into the database by use of the PreparedStatement API, but no row is inserted and no exception is thrown. Here is my my sample program: import java.sql.*; public class…
Achaius
  • 5,904
  • 21
  • 65
  • 122
2
votes
1 answer

Phoenix connection from NIFI on a kerberos cluster

I am trying to connect Phoenix on kerberos cluster from NiFi's DBCP Connection Pool. But failed in creating JDBC driver. DataBase connection URL:…
s p
  • 789
  • 1
  • 6
  • 23
2
votes
2 answers

Phoenix: Convert String column to Integer column

I am looking for a Built-in UDF or any other method to convert values of a string column to integer in my phoenix table for sorting using SELECT and ORDER BY. I searched in the apache language Manual, but no use. Any other suggestions also…
scoder
  • 2,451
  • 4
  • 30
  • 70
2
votes
0 answers

Need explanation of hfile bulk load using uncommitted iterator and rollback

I have inherited a piece of Scala code that uses an odd approach to inserting data into Phoenix HBase tables. It opens a JDBC connection and executes an UPSERT statement against the target. It then obtains an 'UncommittedDataIterator' and…
5nh
  • 27
  • 3
2
votes
0 answers

Phoenix - Client shell Exception while starting the client services(Thin & Thick)

I have facing "NoClassDefFoundError" When execute the phoenix thin client via terminal. Log Details Exception Details fro thin clients: [ERROR] Terminal initialization failed; falling back to unsupported java.lang.NoClassDefFoundError: Could not…
BASS KARAN
  • 181
  • 6
2
votes
1 answer

Write Spark dataframe to Hbase using phoenix connector

I have Hive table which points to Hbase table. I have a spark job which creates dataset having schema equal to hbase table. I am saving this dataframe to hbase table using below command. sql.write().format("org.apache.phoenix.spark") …
Aditya Calangutkar
  • 486
  • 1
  • 6
  • 21
2
votes
0 answers

Wildfly Apache Spark - Application not getting deployed Could not build ClassFile

I am trying to deploy a web application which has dependencies on Spark version 2.1.1, Hbase 1.2, Phoenix 4.11 and Kafka 0.9. The application is not getting deployed, the error I am encountering is given below. It is regarding javassist, the default…
Lokesh Kumar P
  • 369
  • 5
  • 20
2
votes
0 answers

Apache Nifi for MS SQL CDC using dynamic SQL query

In our legacy architecture, we have a MS SQL server database, this database stores all the sensor information in near real time basis, on average per second it receives 100 records.In order to get complete information about the sensor events, we…
nilesh1212
  • 1,561
  • 2
  • 26
  • 60
1 2 3
…
46 47