Re: Unable to use some functions on DECIMAL columns

2020-07-31 Thread Simon Mottram
Hi Josh Thanks very much for the reply, I did share the error at the top of the email SQL Error [0]: Error -1 (0) : Error while executing SQL "ESELECT PERCENTILE_DISC (0.5) WITHIN GROUP (ORDER BY DECIMALCOLUMN ASC) FROM TEST.TESTEXCEPTIONS": Remote driver error: ArrayIndexOutOfBoundsExc

Re: Unable to use some functions on DECIMAL columns

2020-07-31 Thread Josh Elser
Simon, If you have clear bug report, please open up a Jira issue for it. Keep in mind that as much information as you can provide to indicate the problem you see, the better. Assume that whoever might read your Jira issue is coming from zero-context. Right now, you haven't shared any error, s

Re: Add pseudo columns to an existing view

2020-07-31 Thread Josh Elser
Yes. Please see the docs which illustrate how to create views. On 7/28/20 2:12 AM, Arun J wrote: Team, Can we create or alter a view to add a column which is pseudo columns such as # FULLNAME from other columns such as FIRSTNAME + LASTNAME # NUMVALUE from other columns TO_NUMBER(STRVALUE) Th

Re: how to connect phoenix cluster enabled with Kerberos using Java JDBC

2020-07-31 Thread Josh Elser
You're missing a colon between the port and root znode in your JDBC URL. From http://phoenix.apache.org/ ``` jdbc:phoenix [ : [ : [ : [ : [ : ] ] ] ] ] ``` On 7/23/20 4:24 AM, Istvan Toth wrote: The code looks OK. Check that you can resolve the name of, and have IP connectivity to *each *HB