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

Phoenix - JDBCTemplate update

I have problem with upserting values in apache phoenix via Spring JdbcTemplate. Query works fine, so i connect correctly with Phoenix. Also when i make update via straight JDBC it works. Only when i use update method it does not produce any effect…
user2448792
  • 1
  • 1
  • 3
0
votes
1 answer

Phoenix not connected on zookeeper from Cloudera CDH5 distribution

I installed zookeeper, hbase-master, hbase-regionserver in theree different systems. And configured according to the CDH5 guideline. Able to start all the services. Added Phoenix-4.2.2 on zookeeper node. When trying to connect database by ./sqlline…
Gouranga Sarkar
  • 1
0
votes
1 answer

log4j warning connecting to apache Phoenix database

I have Apache Phoenix installed on a cloudera cluster. I'm trying to connect to the database and run some simple SQL commands. My code is below. I'm creating an executable jar file locally and running it on the cluster. I'm getting the following…
scalauser
  • 449
  • 1
  • 12
  • 23
0
votes
1 answer

Phoenix primary key does not link to Row key in HBase

I have created a table using Phoenix command prompt and it is working fine. CREATE TABLE CUSTOMERS (ID INTEGER NOT NULL PRIMARY KEY, NAME VARCHAR(40), CITY CHAR(25)); I'm facing following issues. Primary Key ID created above does not represent…
Abhi
  • 115
  • 3
  • 14
0
votes
1 answer

Epoch time as string comparison

I am working with HBase DB through Phoenix, and I need to compare two Strings of epoch timestamp. the method to_number("ts") takes too long to compute for big amount of data. What is the best practice for comparing two string of epoch timestamps…
Yuval
  • 371
  • 4
  • 13
0
votes
1 answer

How to connect Apache Phoenix-4.2.1 to eclipse IDE in Ubuntu 14.04

I am new to Phoenix I have connected my Apache Phoenix to HBase and it all going well trough terminal but i need to perform some operation of java on table so can you help me to fix how can i connect my phoenix to eclipse IDE so that i can perform…
Kunal
  • 57
  • 2
  • 11
0
votes
1 answer

How do I run sqlline with Phoenix?

When I try to run Phoenix's sqlline.py localhostcommand, I get WARN util.DynamicClassLoader: Failed to identify the fs of dir hdfs://localhost:54310/hbase/lib, ignored java.io.IOException: No FileSystem for scheme: hdfs at…
schoon
  • 2,858
  • 3
  • 46
  • 78
0
votes
3 answers

Count records of a column after group by in SQL

I'm running this query: SELECT "uname","sip",count(1) as cnt FROM "random_data_date" GROUP BY "uname","sip"; To get something like this: +------------+-----------------+--------------+ | uname | sip | cnt …
Alaa Ali
  • 896
  • 1
  • 12
  • 24
0
votes
1 answer

Correct URL for connecting to hbase using phoenix in java

I have set up Hbase on Pseudo-Distributed mode and have installed Phoenix on it. I can connect to Phoenix using sqlline.py localhost and can use it without any errors. then I tried to connect to Phoenix through Java by using the…
Antariksha Yelkawar
  • 381
  • 1
  • 12
0
votes
1 answer

How to insert csv file into HBase database with help of Phoenix command line tools?

Here is an example:example.sql CREATE TABLE IF NOT EXISTS example ( QUESTION_NO BIGINT NOT NULL, TECHNOLOGY VARCHAR(40), SESSION VARCHAR(40), QUESTION VARCHAR(5000), OPTION_A VARCHAR(400),OPTION_B VARCHAR(400), OPTION_C VARCHAR(400),OPTION_D…
Praveen Kumar K R
  • 1,762
  • 2
  • 11
  • 7
0
votes
1 answer

Querying multiple columns from a json object stored in hbase

We have a json data stored under a single column family and this has several name/value pairs. We query this data with different name/value combinations and these queries do not particularly incline towards any name/value pairs (which makes it…
user3259495
  • 1
  • 1
0
votes
1 answer

How to drop system tables in phoenix

Need to drop system table in phoenix. SYSTEM.CATALOG & SYSTEM.SEQUENCE drop table SYSTEM.CATALOG; Table undefined. tableName=SYSTEM.CATALOG select * from SYSTEM.CATALOG is working Also not able to drop from habse. (Saying table not disabled…
neeraj
  • 890
  • 2
  • 15
  • 22
0
votes
1 answer

Unable to fetch the updated Data in hbase through pig after storing using HbaseStorage function?

I am new to pig Scripting . I am unable to fetch the data which i have stored through pig script into hbase using HbaseStorage(). But when i am trying to fetch the data using phoenix i am able to see the data . Can anyone help me out ?
SharanTheja
  • 5
  • 4
0
votes
0 answers

phoenix hbase not connecting remotely

I have two cloudera VM and on both i've configured phoenix and it is working fine as long as it is localhost. When i'm trying to connect hbase from one VM from phoenix of another VM, i'm using this command $ ./sqlline.sh xxx.xx.xx.xx:2181 The…
Aditi Hegde
  • 13
  • 6
0
votes
1 answer

Unable to load the HFiles into HBase using mapreduce.LoadIncrementalHFiles

I want to insert the out-put of my map-reduce job into a HBase table using HBase Bulk loading API LoadIncrementalHFiles.doBulkLoad(new Path(), hTable). I am emitting the KeyValue data type from my mapper and then using the HFileOutputFormat to…
ASingh
  • 475
  • 1
  • 13
  • 24
1 2 3
…
46
47