Hi,
I have created a table with 40 columns and secondary index on 35 of the columns
individually.
Loaded around half million records. Data in all columns is smaller size. For a
long time, the index had not been updated. It almost took overnight to catch up
with all the records.
Is this us
I have a table with many dynamic fields. Works great. However, it's a bit
of a nuisance to have to supply each dynamic field's type in every query.
Example:
select "dynamic_field" from MY_TABLE("dynamic_field" varchar)
This example is not too bad, but image it with 5+ dynamic fields being
used.
Done! https://issues.apache.org/jira/browse/PHOENIX-2709 .
On Tue, Feb 23, 2016 at 3:15 PM, Sergey Soldatov
wrote:
> Hi Steve,
> It looks like a bug. So, please file a JIRA.
>
> Thanks,
> Sergey
>
> On Tue, Feb 23, 2016 at 12:52 PM, Steve Terrell
> wrote:
> > I came across a 4.6.0 query that I
Hi Steve,
It looks like a bug. So, please file a JIRA.
Thanks,
Sergey
On Tue, Feb 23, 2016 at 12:52 PM, Steve Terrell wrote:
> I came across a 4.6.0 query that I could not make work unless I add a
> "limit" to the end, where it should be totally unnecessary.
>
> select * from BUGGY where F1=1 an
I came across a 4.6.0 query that I could not make work unless I add a
"limit" to the end, where it should be totally unnecessary.
select * from BUGGY where F1=1 and F3 is null
results in no records found
select * from BUGGY where F1=1 and F3 is null limit 999
results (correctly) in one record fou
Thank you very very much. I solved it! $HBASE_HOME was not set.
HBASE_HOME=/etc/hbase
export HBASE_HOME
/usr/bin/phoenix-sqlline.py localhost:2181:/hbase
-- Johannes
Am 22.02.2016 um 17:01 schrieb James Taylor:
Your client-side hbase-site.xml is likely not getting picked up. Make
sure it's on t
Thanks Sergey. I tried as per the suggestion and by having a look at the
Phoenix code base. But still dont get the expected result. I have pasted
the java code, *valueStr * is always coming as null for me. Also tried
appending 0x00 that didnt give me result as well.
*Primary Column Values : *