When running "ALTER TABLE xxx DROP COLUMN yyy" on a table with about
6M rows (which I considered small enough), it's always timing out and
I can't see how to get it execute at least once successfully.
I was getting some internal Phoenix timeouts, but after setting the
following properties, it chan
This depends on the exact version of Avatica you are using, because it's
different in all released versions.
In this comment you can see an example of running UPSERT with 1.4 with the
JSON serializer (I think Phoenix 4.7 includes that version):
https://issues.apache.org/jira/browse/CALCITE-1050?f
On Fri, Feb 5, 2016 at 8:46 PM, Steve Terrell
wrote:
>
> When I tried to send a "createStatement" via curl and via Lukas's
> phoenixdb, I got these error's respectively:
>
> HTTP ERROR: 500
> Problem accessing /. Reason:
> Cannot find parser for
>
>
> File "/usr/local/lib/python2.7/site-pac
On Sat, Feb 6, 2016 at 12:53 AM, Steve Terrell
wrote:
> These two incidents leads me to guess that root cause of my issue with
> pythondb is that it was not correctly recognizing the Avatica version.
>
Unfortunately, there is no good way to automatically recognize the Avatica
version just by usi
On Sat, Feb 6, 2016 at 7:28 AM, James Taylor wrote:
> Lukás - your Python Query Server support would be a welcome addition to
> Phoenix or Avatica. Send us a pull request for a new module if you're
> interested.
>
I was considering that when I got the first working version, but I was not
sure ho
On Fri, Apr 29, 2016 at 2:58 AM, Vladimir Rodionov
wrote:
> >> 2. Is it okay that one regionserver is 10x as loaded as others?
>
> Does this server host hbase:meta?
>
I think the high reqs/sec is actually caused by the Phoenix's system tables
being on that regionserver, particularly SYSTEM.CATAL
On Thu, Aug 11, 2016 at 9:00 AM, ankit beohar
wrote:
> I want to implement If null in apache phoenix like mysql.
>
> select ifnull(rowkey,myvalue),ifnull(col1,mycolvalue) from table where
> rowkey='abc';
>
> I tried below query but did not work:-
>
> select case when APP_KEY is null then 'nullval
gt;
>
> On Thu, Aug 11, 2016 at 9:18 PM, James Taylor
> wrote:
>
>> Lukáš is correct, but if the CASE WHEN variant of the same didn't work,
>> please file a JIRA (ideally with a unit test that repros the problem).
>>
>> Thanks,
>> James
>>
&g
Hello,
I have released new version of the Python client library for working with
Phoenix. Thanks to Mark Heppner it now uses the Protocol Buffers interface
instead of JSON, which fixes some issues with Phoenix 4.8. Additionally,
this version supports both Python 2 and Python 3.
Since these were f
ards,
> James
>
> On Thu, Mar 23, 2017 at 5:21 PM, Dimitri wrote:
>>
>> Hi,
>>
>> I make some update on my fork of Lukáš Lalinský phoenix python lib.
>>
>> I integrate sqlalchemy and correct some bug.
>>
>> you can find the code source on http
but I have not validated this.
>
> On Thu, Mar 1, 2018 at 10:34 AM, Ankit Singhal wrote:
> > Re-opening the thread as I can extend help towards the IP clearance
> > process[1] to include python-phoenixdb[2] if Lukas Lalinsky and community
> > agrees to it.
> >
> >
Hi all,
Over the last couple of days I have implemented a Python implementation of
the Avatica RPC client and a package with the standard Python DB API 2.0
interface that uses the client, allowing it to talk to the Phoenix query
server. The project is in very early stage, but it passes the most co
have a couple critiques of Avatica, for instance CALCITE-767. We
> do have a ticket for passing exceptions back to the client, CALCITE-645.
> Are there other issues you've encountered?
>
> -n
>
> +Calcite
>
> On Sun, Jun 28, 2015 at 11:27 AM, Lukáš Lalinský
> wro
I have a couple of questions, some of which might be bugs, but maybe it's
just me misunderstanding something.
I understand that internally the TIME and DATE datatypes are identical. The
only difference is in how the interface handles them.
It seems a little strange to me that the only accepted fo
Even more adventurous option would be to write a native .NET client for the
query server. :)
My Python implementation could be used as a reference for that:
https://bitbucket.org/lalinsky/python-phoenixdb/src/master/phoenixdb/?at=master
There are some problems with the current query server in Ph
I have noticed that Phoenix 4.5 has been released a few days back, but I
see that it still uses Calcite 1.2. That makes the query server only usable
for basic types (varchar and some integer types) and upgrade to 1.3 would
have fixed that. It seems that 1.4 should be released relatively soon. Are
t
On Sat, Aug 22, 2015 at 1:26 AM, Ns G wrote:
> But, what I can suggest is with minimal changes to the phoenix code you
> will be able to build & deploy phoenix on CDH 5.4.x version.
>
> I didn't try phoenix query server but I was able to generate all server
> and client jars and deploy on CDH 5.4
I have just downloaded the 4.5.1 bin package and it seems that there is no
phoenix-server JAR file in it.
Running queryserver.py fails with:
Error: Could not find or load main class
org.apache.phoenix.queryserver.server.Main
I assume this is just a mistake, or has the way to start the server cha
You need to set "hbase.rpc.timeout" to the same value as you have for
"phoenix.query.timeoutMs".
It seems that in the pre-Apache version of Phoenix it was set automatically:
https://issues.apache.org/jira/browse/PHOENIX-269?focusedCommentId=14681924&page=com.atlassian.jira.plugin.system.issuetabp
19 matches
Mail list logo