Member since
12-09-2015
14
Posts
5
Kudos Received
0
Solutions
01-21-2016
06:15 PM
i use happybase for python. thrift server is on server side or client side?
... View more
01-20-2016
11:05 PM
1 Kudo
I am trying to connect Hbase using happybase. But I got connection error when trying to connect hbase using 9090 port. I'm wondering if I need to setup thrift from Hbase configuration. How to enable the port to setup the connection?
... View more
Labels:
- Labels:
-
Apache HBase
01-08-2016
06:35 PM
Is there any example to get data from Hbase using Spark in Hortonworks? MapR and Cloudera has some packages like this, not sure if it could work in Hortonworks.
... View more
01-08-2016
06:30 PM
I need to firstly run query to select records based on time, and then dump data into files or data frame. Happybase can't support query and its index has to be integer. Could you lead me some example on mapreduce or pig example?
... View more
01-08-2016
06:21 PM
It seems that the above can't satisfy all my need. What's the best way to get data out of hbase and save into files instead?
... View more
12-16-2015
12:12 AM
1 Kudo
In my previous tables in Hbase, each column family has many qualifier: values pairs. When I try to create a view in Phoenix, no values shown in these columns. How to create a view to map all schema in my exsiting tables?
... View more
Labels:
- Labels:
-
Apache Phoenix
12-15-2015
10:51 PM
[root@cui-hdp-02 phoenix]# sqlline.py localhost:2181:/hbase-unsecure
Setting property: [isolation, TRANSACTION_READ_COMMITTED]
issuing: !connect jdbc:phoenix:localhost:2181:/hbase-unsecure none none org.apache.phoenix.jdbc.PhoenixDriver
Connecting to jdbc:phoenix:localhost:2181:/hbase-unsecure 15/12/15 14:50:24 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable 15/12/15 14:50:42 ERROR zookeeper.RecoverableZooKeeper: ZooKeeper exists failed after 4 attempts 15/12/15 14:50:42 ERROR zookeeper.ZooKeeperWatcher: hconnection-0x4034c28c0x0, quorum=localhost:2181, baseZNode=/hbase-unsecure Received unexpected KeeperException, re-throwing exception
org.apache.zookeeper.KeeperException$ConnectionLossException: KeeperErrorCode = ConnectionLoss for /hbase-unsecure/hbaseid
... View more
12-15-2015
10:49 PM
root@cui-hdp-02 ~]# hbase version
2015-12-15 14:49:15,713 INFO [main] util.VersionInfo: HBase 1.1.2.2.3.2.0-2950 I used phoenix-4.6.0-HBase-1.1-bin.tar.gz
... View more
12-15-2015
10:45 PM
1 Kudo
I tried Phoenix and installed it according to the instruction, but I got the following error message: [root@cui-hdp-02 phoenix]# sqlline.py localhost Setting property: [isolation, TRANSACTION_READ_COMMITTED] issuing: !connect jdbc:phoenix:localhost none none org.apache.phoenix.jdbc.PhoenixDriver Connecting to jdbc:phoenix:localhost 15/12/15 14:17:14 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable 15/12/15 14:17:14 WARN impl.MetricsConfig: Cannot locate configuration: tried hadoop-metrics2-phoenix.properties,hadoop-metrics2.properties 15/12/15 14:17:15 ERROR client.ConnectionManager$HConnectionImplementation: The node /hbase is not in ZooKeeper. It should have been written by the master. Check the value configured in 'zookeeper.znode.parent'. There could be a mismatch with the one configured in the master. My hbase's znode is by default defined as /hbase-unseure. How can i change phoenix to use current znode, instead of /hbase?
... View more
Labels:
- Labels:
-
Apache Phoenix
12-15-2015
10:40 PM
1 Kudo
I tried Phoenix and installed it according to the instruction, but I got the following error message: [root@cui-hdp-02 phoenix]# sqlline.py localhost
Setting property: [isolation, TRANSACTION_READ_COMMITTED]
issuing: !connect jdbc:phoenix:localhost none none org.apache.phoenix.jdbc.PhoenixDriver
Connecting to jdbc:phoenix:localhost 15/12/15 14:17:14 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable 15/12/15 14:17:14 WARN impl.MetricsConfig: Cannot locate configuration: tried hadoop-metrics2-phoenix.properties,hadoop-metrics2.properties
15/12/15 14:17:15 ERROR client.ConnectionManager$HConnectionImplementation: The node /hbase is not in ZooKeeper. It should have been written by the master. Check the value configured in 'zookeeper.znode.parent'. There could be a mismatch with the one configured in the master. My hbase's znode is by default defined as /hbase-unseure. How can i change phoenix to use current znode, instead of /hbase?
... View more
12-15-2015
08:00 PM
1 Kudo
What's the best practice to get data from hbase and form dataframe for Python/R? If we want to use our Panda/R libraries, how to get data from hbase and form dataframe automatically?
... View more
Labels:
- Labels:
-
Apache HBase
-
Apache Spark
12-11-2015
06:42 PM
As Hbase has no its build-in query language, I'm wondering the best practice of hbase query..by spark, Phoenix, solar? We need select, group by, join operations mostly. How to decide which technique is right for our case?
... View more
Labels:
- Labels:
-
Apache HBase
12-10-2015
06:04 PM
Thanks for all your answers. I was tried to put /etc/hbase/conf/hbase-site.xml into $CLASSPATH or $PATH but not able to work out. However, when I put it into jar -cp directory. It works!
... View more
12-09-2015
07:15 PM
After default install, I can use Hbase shell to create tables. But when I tired to use Java API to do the same thing, I got the above mismatch issue. I found the default install seems not setup zookeeper's myid file in Habase master node. there is no znode called '/hbase-unseure" in zookeeper znode folder. How to configure Hbase and Zookeepr and test if they are running well? It seems that HW default install does not make ZK and Hbase configure automatically correct?
... View more
Labels:
- Labels:
-
Apache HBase