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

Show Index in Apache Phoenix

I have Apache Phoenix 4.4 installed on HDP 2.3. Does anyone know how to view all indexes created on a table? Like MySQL has show index on table_name query. I couldn't find help on the documentation here.
Raman
  • 1,221
  • 13
  • 20
3
votes
1 answer

How to run web application on hadoop and phoenix

I installed hadoop,hbase and phoenix in ubuntu 14 and runed a simple example for connecting phoenix in eclipse. It's work and execute my query. public static void execute() throws ClassNotFoundException { Connection connection = null; …
NASRIN
  • 475
  • 7
  • 22
3
votes
1 answer

How to delete from apache phoenix querying by fields not in every index

I try to execute statement DELETE FROM statistics WHERE statistic_id is null and geting error: java.sql.SQLException: ERROR 1027 (42Y86): All columns referenced in a WHERE clause must be available in every index for a table with immutable rows.…
Artur Bartnik
  • 116
  • 1
  • 6
3
votes
2 answers

ODBC driver for HBase/Phoenix

I need to connect Tableau to HBase or Phoenix and Tableau does not support JDBC. Bummer! I've read about the proprietary Simba driver but haven't seen any reports of people using it. I don't feel like forking over money when it's not ideal, and my…
Ian
  • 1,294
  • 3
  • 17
  • 39
3
votes
2 answers

why hbase KeyValueSortReducer need to sort all KeyValue

I am learning Phoenix CSV Bulk Load recently and I found that the source code of org.apache.phoenix.mapreduce.CsvToKeyValueReducer will cause OOM ( java heap out of memory ) when columns are large in one row (In my case, 44 columns in one row and…
CrazyPig
  • 137
  • 12
3
votes
2 answers

Apache Phoenix Current Time

I am trying Apache Phoenix with Hbase. When I run try to get current time using select current_time(), its giving me some weird value. (292278994-08-17 07:12:55.807). Similarly for current_date() or now() query. I am not able to understand what does…
Ankit Agarwal
  • 31
  • 1
  • 3
3
votes
1 answer

"Column reference ambiguous or duplicate names" on Apache Phoenix when using alias

Using Apache Phoenix 4.6.0 against HBase 1.1.2. I have a simple table created like this: CREATE TABLE "events" ( "uuid" VARCHAR(64) PRIMARY KEY, "event"."session" VARCHAR(64), "event"."name" VARCHAR(32), "event"."date"…
Thomas Decaux
  • 21,738
  • 2
  • 113
  • 124
3
votes
1 answer

Phoenix; How to create a view with case

I am trying to create a view on a table in Apache Phoenix and add/change the values of one of the base table columns in the view. Something like this: CREATE VIEW mobile_product_metrics (new_col varchar) AS SELECT * , (CASE metric_type WHEN 'm' THEN…
Afshin Moazami
  • 2,092
  • 5
  • 33
  • 55
3
votes
1 answer

phoenix and query timeout

I have a very large hbase/phoenix table that I am trying to query using sqlline. I am getting the following exception. I tried changing various settings both on client and…
kostas.kougios
  • 945
  • 10
  • 21
3
votes
1 answer

PhoenixOutputFormat not found when running a Spark Job on CDH 5.4 with Phoenix 4.5

I managed to configure Phoenix 4.5 on Cloudera CDH 5.4 by recompiling the source code. sqlline.py works well, but there are problems with spark. spark-submit --class my.JobRunner \ --master yarn --deploy-mode client \ --jars `ls -dm /myapp/lib/* |…
Nicola Ferraro
  • 4,051
  • 5
  • 28
  • 60
3
votes
2 answers

HDP: unable to start Phoenix sqlline.py

I am using Sandbox HDP 2.2 I did a yum install phoenix (version is 4.2) But when I run these: ./sqlline.py localhost:2181 ./sqlline.py localhost ./sqlline.py sandbox.hortonworks.com:2181 ./sqlline.py sandbox.hortonworks.com I got the…
sophie
  • 991
  • 2
  • 15
  • 34
3
votes
1 answer

Using Phoenix with Hbase standalone throws NoSuchMethodError

I have downloaded the tar.gz package for Hbase(1.1) and Phoenix(4.4 for hbase 1.1) Setting up hbase in standalone mode works, I can get into the hbase shell. Next I placed all .jar files from the the phoenix dir into Hbase's lib folder. However,…
Havnar
  • 2,558
  • 7
  • 33
  • 62
3
votes
1 answer

HBase is not starting in windows

I am trying to use HBase in windows and I am new to it. I am getting the following errors while I was trying to run the file start-hbase.cmd C:\Users\tb\Desktop\GA_Works\hbase-1.0.0\bin>start-hbase.cmd Invalid maximum heap size: -Xmx1000m " Error:…
user4556747
3
votes
1 answer

Phoenix JDBC driver too slow

I am using phoenix driver 4.0 version to query database. I have also tried setting hbase.client.scanner.caching to 1000 and 10000 In all the cases it takes 3 minutes to iterate over 10000 rows. I have not put any code inside iteration loop. I have…
sunilsurana
  • 113
  • 1
  • 9
2
votes
1 answer

apache tomcat start fails with phoenix-5.0.0-HBase-2.0-client.jar in project lib folder

i have a web application which connects to apache phoenix; therefore i added phoenix-5.0.0-HBase-2.0-client.jar to dependencies and it works perfectly in intellij on local but when i start tomcat in server i get this error…
mohaddese abbasi
  • 91
  • 7
1 2 3
…
46 47