You can enable remote debugging on regionserver by appending "-Xdebug
-Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=8071" to
HBASE_REGIONSERVER_OPTS and debug through eclipse.
On Tue, Jan 12, 2016 at 7:08 PM, Gaurav Agarwal
wrote:
> Hello
> How to debug custom udf In phoenix.I wrote
As Afshin also said, You need to adjust your timezone with
phoenix.query.dateFormatTimeZone
https://phoenix.apache.org/tuning.html
phoenix.query.dateFormatTimeZone
IST
for eg:-
*upsert like this:*-
jdbc:phoenix:localhost> UPSERT INTO DESTINATION_METRICS_TABLE VALUES
(to_date('2015-09-12 22:02
Hi Gabriel,
This worked perfectly.
Thanks a lot.
Parth S
On Fri, Jan 29, 2016 at 10:29 PM, Gabriel Reid
wrote:
> Hi Parth,
>
> Setting the "fs.permissions.umask-mode" config setting to "000" should
> do the job. You can do this in your hadoop config on the machine where
> you're submitting the
Hi Parth,
Setting the "fs.permissions.umask-mode" config setting to "000" should
do the job. You can do this in your hadoop config on the machine where
you're submitting the job, or just supply it as the leading
command-line parameter as follows:
hadoop jar phoenix-client.jar
org.apache.phoen
Hi Swapna,
We currently don't support custom aggregate UDF, and it looks like you
found the JIRA here: PHOENIX-2069. It would be a natural extension of UDFs.
Would be great to capture your use case and requirements on the JIRA to
make sure the functionality will meet your needs.
Thanks,
James
On F
That doesn't seem to work.
Phoenix is not recognizing that created_at in the WERE clause is a derived
column from to_date("created_at_date").
Some relational databases support this type of functionality.
On Fri, Jan 29, 2016 at 4:16 PM, Alok Singh wrote:
> Does this work:
>
> select 1, to_date
Does this work:
select 1, to_date("created_at_date") as created_at from "gp_subscriptions"
where created_at > to_date('2010-10-10') limit 3;
Alok
Alok
a...@cloudability.com
On Fri, Jan 29, 2016 at 3:54 PM, Binu Mathew wrote:
> Thank you for the reply.
>
> I mistakenly wrote that we are using
Thank you for the reply.
I mistakenly wrote that we are using Phoenix with HBase .96. This was a
typo. We are using HBase .98 with Phoenix 4.4
I tried the UNSIGNED types and still encountering the same issue.
My field has the following data:
select "created_at_date" from "gp_subscriptions" limi
Hi,
I would like to know the approach to implement and register custom
aggregate functions in Phoenix like the way we have built-in aggregate
functions like SUM, COUNT,etc
Please help.
Thanks
Swapna
Hi
I'm trying to run the PhoenixBulkLoader command as user 'X' where user 'X'
!= hbase. Basically the bulkloader waits on loading the HFiles from hdfs if
I run the command as any other user except 'hbase'.
Is there some way to run the command as just any user except 'hbase' on an
un-secure cluster.
Thanks Ankit, trying your suggestions.
From: Ankit Singhal [mailto:ankitsingha...@gmail.com]
Sent: Friday, January 29, 2016 10:43
To: user@phoenix.apache.org
Subject: Re: Phoenix Query exception on few tables
can you check HBase master page and see if some regions are in transition or
failing in
can you check HBase master page and see if some regions are in transition
or failing in opening/closing?
If yes, then restart your master or try to assign region with * assign
‘REGION_NAME’.*
And run *hbck *to detect any consistency and fix them.
http://hbase.apache.org/book.html#hbck.in.depth
yo
Can someone please help? It's very sporadic and not sure where to start looking
into this issue. Many thanks.
From: Ramanathan, Kannan: IT (NYK)
Sent: Thursday, January 28, 2016 14:04
To: user@phoenix.apache.org
Subject: Phoenix Query exception on few tables
We have started seeing PhoenixIOExcep
13 matches
Mail list logo
