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

Can Phoenix v4.4 utilize HBase namespaces?

As we've been evaluating the use of Phoenix + HBase in HortonWorks 2.3, we came upon the conclusion that in the current bundled version of Phoenix, 4.4, that namespaces are not supported. The upstream JIRAs are confusing but it looks like Phoenix…
slm
  • 15,396
  • 12
  • 109
  • 124
0
votes
2 answers

Is it possible to load Phoenix tables from HDFS?

I am new to Phoenix. Is there any way to load tables to Phoenix from hadoop filesystem ?
zebb
  • 3
  • 2
0
votes
1 answer

Hbase Filters in Apache Phoenix

I am searching Hbase prefix filter in Apache Phoenix, is it available in phoenix? My rowkey like 12345_@_)*6 now I want to run below Hbase scan in Apache Phoenix:- scan 'tablename',{FILTER=>"PrefixFilter('12345_@')"}
ankitbeohar90
  • 109
  • 13
0
votes
1 answer

Using limit and offset in phoenix query

I am trying to get 10 records from a merged table, after skipping the first 10 records. I execute the following query in Phoenix(using SQuirreL SQL Client Version 3.7.1) as we do in MySQL: select /*+USE_SORT_MERGE_JOIN*/ * from "ds_jatin",…
psr
  • 2,619
  • 4
  • 32
  • 57
0
votes
3 answers

Spark/Phoenix with Kerberos on YARN

I have a Spark (1.4.1) application that runs on a non-kerberized cluster and I copied it to another instance that has Kerberos running. The application takes data from HDFS and puts it into Phoenix. However, it does not work: ERROR…
Ian
  • 1,294
  • 3
  • 17
  • 39
0
votes
1 answer

[Python]:phoenixdb.errors.ProgrammingError: ("Syntax error. Unexpected char: '!'", 601, '42P00', None)

I am using a python module called phoenixdb to access phoenix which is SQL wrapper to query over HBase. Here is my code snippet:- import phoenixdb database_url = 'http://localhost:8765/' conn = phoenixdb.connect(database_url,…
sam
  • 635
  • 4
  • 9
  • 18
0
votes
1 answer

Can't obtain table data via REST

I created a HBase table using the Phoenix JDBC Driver in the following code snippet: Class.forName("org.apache.phoenix.jdbc.PhoenixDriver"); Connection conn = DriverManager.getConnection("jdbc:phoenix:serverurl:/hbase-unsecure"); …
D. Müller
  • 3,336
  • 4
  • 36
  • 84
0
votes
1 answer

Order by Query not wrorking for large records for Pheniox

version of phoenix :-4.4 i am executing a phoenix query by java code in which i was using order by when i run this query but after every 2 and 3 successful execution it shows the following error:- java.lang.RuntimeException: `enter code…
Tanmay Agrawal
  • 77
  • 8
0
votes
1 answer

Query JSON data from HBASE using SPARK SQL

I have a table in HBASE as -------------------------------------------------------------------------- | rowkey | Name | marks | | 1 | ABC | {"mathematics":"30","science":"50"}…
Sangeeta Rawat
  • 199
  • 1
  • 1
  • 15
0
votes
1 answer

Is there any way I can enforce an "API contract" when testing my web app's API and UI separately?

I'm developing an Ember.js app with a Phoenix API. I have followed someone's advice to keep the UI and API as separate projects, and I know that I can use ember-cli-mirage to mock my API during development and testing. But this makes me really…
ndbroadbent
  • 13,513
  • 3
  • 56
  • 85
0
votes
1 answer

MapReduce code runs only in local. How to execute my code in distributed mode?

For a few days I developed a MapReduce code to insert values in HBase with Phoenix. But the code runs only in local and overcharge the machine. Whatever changes I make I observe that the mapred.LocalJobRunner class is systematically used. Do you…
Lucie M
  • 13
  • 2
0
votes
2 answers

Apache Phoenix: Values in UPSERT must evaluate to a constant. java.sql.SQLException: ERROR 204 (22008)

I want to update a table named EMPLOYEE in hbase, which looks like the following and the row key is ID. ID,Name,Age "1","John","34" "2","David","22" I want to add another column named City in this table. Using Apache phoenix I executed this…
userxxx
  • 796
  • 10
  • 18
0
votes
0 answers

Accessing HBase from BIRT using Phoenix

My primary requirement is to use data in HBase for reporting. BIRT is my reporting tool. Phoenix is a JDBC client that allows querying HBase data with SQL like queries. Now, Is there a way for me to use BIRT to report from HBase through Phoenix? Any…
Pon Venkatesh M
  • 11
  • 2
0
votes
1 answer

Apache phoenix 4.5.1 with spark 1.3.1 Classnotfoundexception

We are running spark streaming to get the feed from Kafka. Now we are trying to use Phoenix JDBC to extract some data from HBASE. When I run the code in local its running fine without any issues, but when I run it using yarn-cluster it throws below…
Vignesh I
  • 2,211
  • 2
  • 20
  • 40
0
votes
1 answer

hbase-indexer auto exit when data load frequently

Recently my team is using hbase-indexer on CDH for indexing hbase table column to solr . When we deploy hbase-indexer server (which is called Key-Value Store Indexer) and begin testing. We found a situation that when we put data to hbase (We are…
CrazyPig
  • 137
  • 12
1 2 3
…
46 47