Member since
11-14-2015
268
Posts
122
Kudos Received
29
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2130 | 08-07-2017 08:39 AM | |
3308 | 07-26-2017 06:06 AM | |
8250 | 12-30-2016 08:29 AM | |
6487 | 11-28-2016 08:08 AM | |
5740 | 11-21-2016 02:16 PM |
08-25-2016
02:45 PM
would you mind try again by setting this phoenix.query.force.rowkeyorder to true too. as phoenix.query.rowKeyOrderSaltedTable got deprecated with phoenix.query.force.rowkeyorder in some release.
... View more
08-25-2016
01:56 PM
2 Kudos
"phoenix.query.rowKeyOrderSaltedTable" is the client property, can you make sure hbase-site.xml is in the classpath of your application/sqlline.
... View more
08-22-2016
11:44 AM
@sankar rao, bq. why should i decompress the file..? In order to confirm that file selected is actually corrupted or not. bq. how can i get ..failed container logs because.. i could see 12 directory paths under "yarn.nodemanager.log-dirs" property and .i just confused where should i find the application logs Actually, I don't remember the actual keyword to search in the logs ,but you can check syslogs for container with id similar to _14435*_237788_1_01_000062_1 and look for line saying "processing file" or something similar.
... View more
08-22-2016
09:25 AM
It seems your zip file present in table directory is corrupted. Try decompress the file directly with unzip utility(you may get the file name from the failed container logs).
... View more
08-11-2016
01:29 PM
As sql dialect keywords are case insensitive , so Double quotes(") just helps parser to avoid converting them back to upper case. May be you can create a another view over your current view with case insensitive column name. You may check the actual syntax on the site, JFYR create view view2(col1 integer, col2 integer) as select "col1","col2" from view1;
... View more
08-11-2016
01:18 PM
3 Kudos
It seems your hbase:acl table is not created. can you check hbase-site.xml at master side as well it should have:- <property>
<name>hbase.coprocessor.master.classes</name>
<value>org.apache.hadoop.hbase.security.access.AccessController</value>
</property> try restarting your cluster as postStartMaster step should create this table, once you are able to do scan 'hbase:acl' , you will not see above error "ERROR: DISABLED:Security features are not available"
... View more
08-10-2016
09:18 AM
I don't know about any reset service in hbase, would you mind sharing the reference from where you read about it?
... View more
08-09-2016
09:08 AM
1 Kudo
@Saurabh Rathi, the workaround , you can do is to declare your field "eid" as VARCHAR and use TO_NUMBER function to cast it to number during query if required. Or, @Josh Elser said, while storing the data in hbase , you can encode your integer to phoenix representation of INT by using below API.(same for other data types) byte[] byte_representation = PInteger.INSTANCE.toBytes(<integer_value>); Please see for more details:-
https://phoenix.apache.org/faq.html#How_I_map_Phoenix_table_to_an_existing_HBase_table
... View more
08-03-2016
03:27 PM
Are you doing commit after upserting rows? as it may be possible that pentaho PDI may set autocommit off before starting inserts.
... View more
08-03-2016
03:23 PM
1 Kudo
is 16000 port also open to allow any IP can connect to this host?
... View more