Re: PQS + Kerberos problems

ave authorization set up correctly between PQS and HBase. > > Specifically, you must have the appropriate Hadoop proxyuser rules set > up in core-site.xml so that HBase will allow PQS to impersonate the PQS > end-user. > > On 5/14/19 11:04 AM, Aleksandr Saraseka wrote: > > Hello

Phoenix backup

Hello community. Can you suggest some flow for doing full backup of Phoenix tables ? We're using global indexes as well, so I wondered how to backup data table + index table simultaneously to prevent full index rebuilding after restoration ? -- Aleksandr Saraseka DBA at EZ Texting M

PQS + Kerberos problems

un(ResultBoundedCompletionService.java:80) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ... 1 more Caused by: org.apache.hadoop.hbase.exceptions.ConnectionClosingException: Call

Re: Phoenix Index Scrutiny Tool

't personally tried it myself. > > On Fri, Aug 9, 2019 at 2:18 PM Alexander Batyrshin <0x62...@gmail.com> > wrote: > >> I have familiar question - how to partially rebuild indexes by >> timestamps interval like many MapReduce has —starttime/—endttime >> >> On 9 A

Re: Phoenix Index Scrutiny Tool

| +--+---+++ | "ALEX"."TEST" | "ALEX"."GLOBAL_DATA1_DATA2_INC_DATA3" | 1565689347373 | 3e3aa2997d0bbf9b4d7247 | On Tue, Aug 13, 2019 at 12:43 PM Aleksandr Saraseka wrote: > @Vincent - I d

Re: Is there any way to using appropriate index automatically?

dex automatically. I create a > local index and a query with corresponding index column filter in where > clause. But the query doesn’t use index, with index hint it uses it. -- Aleksandr Saraseka DBA 380997600401 *•* asaras...@eztexting.com *•* eztexting.com <http://eztexting.co

PSQ processlist

Hello. Does Phoenix Query Server have any possibility to track running queries ? Like user connects with thin client and run some long running query, can I understand who and what is running ? -- Aleksandr Saraseka DBA 380997600401 *•* asaras...@eztexting.com *•* eztexting.com <h

Re: PSQ processlist

Thank you Josh, this is very helpful. Another question - can we kill long running query in PQS somehow ? On Mon, Sep 9, 2019 at 5:09 PM Josh Elser wrote: > Not unique to PQS, see: > > https://issues.apache.org/jira/browse/PHOENIX-2715 > > On 9/9/19 9:02 AM, Aleksandr Saraseka w

Re: Phoenix with multiple HBase masters

se master node? > - do we need to install new query server on the hbase master? > - any configuration changes should we make? > - do we need an ELB for the query server? > > Thanks > > > > -- Aleksandr Saraseka DBA 380997600401 *•* asaras...@eztexting.com *•* eztexting.

Re: Phoenix with multiple HBase masters

iting as a standby in case the current active master >> dies for some reason (expectedly or unexpectedly). >> >> On 8/7/19 9:55 AM, Aleksandr Saraseka wrote: >> > Hello. >> > - Phoenix libs should be installed only on RegionServers. >> > - QueryServer - it

Re: Secondary Indexes - Missing Data in Phoenix

\x00\x00> > > > > > > > > > \x00\x00\x00\x00\x00\x00\x> > > > > > > > > > 151545413\x00\x00\x> > > > > > > > > > 00\x00\x01b\xB2s\xDB@\x1B\> > > > > > > > > > x94\xFA\xD4\x14c\x0Bd$\x82> > > > > &

Phoenix Index Scrutiny Tool

? -- Aleksandr Saraseka DBA 380997600401 *•* asaras...@eztexting.com *•* eztexting.com <http://eztexting.com?utm_source=WiseStamp_medium=email_term=_content=_campaign=signature> <http://facebook.com/eztexting?utm_source=WiseStamp_medium=email_term=_content=_campaign=signatu

Re: Index on SYSTEM.LOG failed

wrote: > Do you have a mismatch of Phoenix thinclient jars and Phoenix > QueryServer versions? > > You're getting a classpath-type error, not some Phoenix internal error. > > On 10/24/19 10:01 AM, Aleksandr Saraseka wrote: > > Hello. We're logging queries in Phoenix. > &g

Re: Phoenix index REBUILD stuck in BUILDING state

Hello Niraj. You can use ASYNC option and then rebuild index with IndexTool (map-reduce under the hood) https://issues.apache.org/jira/browse/PHOENIX-2890

Index on SYSTEM.LOG failed

sqlline.SqlLine.begin(SqlLine.java:686) at sqlline.SqlLine.start(SqlLine.java:398) at sqlline.SqlLine.main(SqlLine.java:291) at org.apache.phoenix.queryserver.client.SqllineWrapper.main(SqllineWrapper.java:93) -- Aleksandr Saraseka DBA 380997600401 *•* asaras...@eztexting.com *•* eztexting.com

Phoenix non-Kerberos security ?

only to some tables) without enabling Kerberos for HBase/HDFS clusters. -- Aleksandr Saraseka DBA 380997600401 *•* asaras...@eztexting.com *•* eztexting.com <http://eztexting.com?utm_source=WiseStamp_medium=email_term=_content=_campaign=signature> <http://facebook.com/eztexting?u

Re: Phoenix non-Kerberos security ?

whether Queryserver supports security or not. In worst case, a > potential workaround would be to put Phoenix query server behind a > homegrown webservice that authenticates and authorizes the users before > forwarding the request to Queryserver. > > HTH, > Anil Gupta > >

Re: Query on phoenix upgrade to 5.1.0

date to any system tables schema. > > As such, you need to make sure that this client has permission to alter > the phoenix system tables that exist, often requiring admin-level access > to hbase. Your first step should be collecting DEBUG log from your > Phoenix JDBC client on upgrad

Re: Query on phoenix upgrade to 5.1.0

lientScanner.java:595) >> > at >> > >> >> org.apache.phoenix.coprocessor.ViewFinder.findRelatedViews(ViewFinder.java:94) >> > at >> > >> >> org.apache.phoenix.coprocessor.MetaDataEndpointImpl.dropChildViews(MetaDataEndpointImpl.java:2488) >> >