2015-07-09 23:36 GMT-07:00 James Taylor :
> Sounds like something else is going wrong. Can you adapt your test by
> setting the MAX_FILESIZE very low for your table (so that it splits after 4
> or 5 rows are added) and package it up as a unit test?
>
> On Thu, Jul 9, 2015 at 1:44 P
g/language/index.html#alter_index
>
> On Thu, Jul 2, 2015 at 5:26 PM, Yufan Liu wrote:
>
>> The query on test dataset is returning the expected result with the
>> patch. But on the original dataset (10million rows, 6 regions), it still
>> return the same unexpected result
The query on test dataset is returning the expected result with the patch.
But on the original dataset (10million rows, 6 regions), it still return
the same unexpected result, I will dig more into this. Thank you, James!
2015-07-02 9:58 GMT-07:00 Yufan Liu :
> Sure, let me have a try
>
>
Sure, let me have a try
2015-07-02 9:46 GMT-07:00 James Taylor :
> Thanks, Yufan. I found an issue and filed PHOENIX-2096 with a patch. Would
> you mind confirming that this fixes the issue you're seeing?
>
> James
>
> On Thu, Jul 2, 2015 at 9:45 AM, Yufan Liu wrot
I'm using 4.4.0-HBase-0.98
2015-07-01 22:31 GMT-07:00 James Taylor :
> Yufan,
> What version of Phoenix are you using?
> Thanks,
> James
>
> On Wed, Jul 1, 2015 at 2:34 PM, Yufan Liu wrote:
>
>> When I made more tests, I find that this problem happens after table
tool), it returns 143024961.
Let know if you find anything. Thanks!
2015-07-01 11:27 GMT-07:00 James Taylor :
> If you could put a complete test (including your DDL and upsert of data),
> that would be much appreciated.
> Thanks,
> James
>
> On Wed, Jul 1, 2015 at 11:20 AM, Y
ossible. Make you use NULLS LAST
> in your ORDER BY as rows are ordered with nulls first.
>
> On Tue, Jun 30, 2015 at 5:25 PM, Yufan Liu wrote:
>
>> I used the HBase reverse scan to find the last row on the index table. It
>> returned the expected result. I would like to know
I used the HBase reverse scan to find the last row on the index table. It
returned the expected result. I would like to know is Phoenix's "ORDER BY"
and "DESC" implemented based on HBase reverse scan?
2015-06-26 17:25 GMT-07:00 Yufan Liu :
> Thank you anyway, Michael!
;
>
>
> Mike
>
>
>
> *From:* Yufan Liu [mailto:yli...@kent.edu]
> *Sent:* Friday, June 26, 2015 7:19 PM
> *To:* user@phoenix.apache.org
> *Subject:* Re: Problem in finding the largest value of an indexed column
>
>
>
> Hi Michael,
>
> Thanks for the a
y attachment is strictly prohibited. If you
> have received this communication in error, please notify the sender
> immediately by reply e-mail and promptly destroy all electronic and printed
> copies of this communication and any attachment.
>
>
>
> *From:* Yufan Liu [mailto:yli
Hi,
We have created a table (eg, t1), and a global index of one numeric column
of t1 (eg, timestamp). Now we want to find the largest value of timestamp,
we have tried two approaches:
1. select max(timestamp) from t1; This query takes forever to finish, so I
think it maybe doing a full table scan
,
> that you may need to remove the double quotes cause
>
> double quotes would got upper case identifiers. BI tool may be leveraged
> to reach that.
>
> Best,
> Sun.
>
> --
> ------
>
> CertusNet
>
&g
Hi James,
I change everything in the query to upper case: select "FACT"."C1" as “C0"
from (select COL1 as C1 from T1) as "FACT”, and it returns the same error:
"Undefined column family. familyName=FACT.null." But when I change to
FACT."C1", it works fine. It seems there is problem with double quot
Hi James,
I have tried the queries you guys are using above (select fact.c1 from
(select k as k1, col1 as c1 from t1) as fact), it works. But in the result
set, it displays the original column name (col1) instead of alias name
(c1). Is that expected behavior?
2015-06-16 13:39 GMT-07:00 James Tay
Hi,
Phoenix supports Double as it's column type, but when I am trying to upsert
a double value (eg, 7.481509313889134E-5), there is an exception comes out:
Error: ERROR 604 (42P00): Syntax error. Mismatched input. Expecting
"RPAREN", got "E".
Seems "E" in double value can not be parsed, did anyon
15 matches
Mail list logo
