nt.ResultBoundedCompletionService$QueueingFuture.run(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
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
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 Text
0\x00\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>
>
> > >
he new hbase 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 *•*
will be waiting 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
by
Primary Key hash ?
--
Aleksandr Saraseka
DBA
380997600401
*•* asaras...@eztexting.com *•* eztexting.com
<http://eztexting.com?utm_source=WiseStamp&utm_medium=email&utm_term=&utm_content=&utm_campaign=signature>
<http://facebook.com/eztexting?utm_source=Wis
umented, and I haven'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
|
+--+---+++
| "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
te index 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.com?utm
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
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
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
qlline.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
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 Phoeni
write 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&utm_medium=email&utm_term=&utm_content=&utm_campaign=signature>
<
gt; check 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 Gupt
.client.ClientScanner.next(ClientScanner.java:595)
>> > at
>> >
>>
>> org.apache.phoenix.coprocessor.ViewFinder.findRelatedViews(ViewFinder.java:94)
>> > at
>> >
>>
>> org.apache.phoenix.coprocessor.MetaDataEndpointImpl.dropChildViews(MetaData
an update 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 u
19 matches
Mail list logo