Hi, the sqline.py works fine in the server console, but when I try to
connect it through python, it gives the following SQLException:
File "/usr/local/lib/python2.7/dist-packages/phoenixdb/avatica.py",
line 129, in parse_error_protobuf
raise errors.InternalError(err.error_message)
phoenixdb.
ane wrote:
>
> Check the database URL
>
> This is how JDBC URL is configured
>
> jdbc:phoenix:thin:url=http://ip-10-46-174-227.ec2.internal:
> 8765;serialization=PROTOBUF;authentication=SPNEGO
>
> Make sure you have proper driver files in system path.
>
> On Mon, Oct
Hi,
I want to update a column's value in all rows by concatenating values from
the multiple columns of the rows. In plain sql it's possible to do that but
I'm not sure if that can be done in Phoenix.
For say I've four columns in a table:
(id, product_id, price, store_id, bill_id)
Now I already
Thank you, Sorry for my poor reading, how I missed it.
Thank you
Vaghawan
On Sat, Oct 28, 2017 at 11:01 PM, James Taylor
wrote:
> See http://phoenix.apache.org/language/index.html#upsert_select
>
> On Sat, Oct 28, 2017 at 4:25 AM Vaghawan Ojha
> wrote:
>
>> Hi,
>
Hi,
I've a one Namenode server and another Datanode server, phoenix query
server are running on both.
For a single request, everything is fine, but when I do multiple requests
simultaneously, the query server timeouts , the table consists only 2-3 gbs
of data.
I think, I'm missing some configura
hbase.regionserver.lease.period
120
hbase.rpc.timeout
120
hbase.client.scanner.caching
1000
hbase.client.scanner.timeout.period
1200000
but with no help. Any suggessation would be great, Mostly
Hi, Are you sure you are pointing to the right path and file? Because the
error says
Caused by: java.io.FileNotFoundException: File does not exist:
hdfs://*
Please make sure the csv file is there.
On Sunday, November 26, 2017, idosenesh wrote:
> Im trying to bulk load into Phoenix using the CsvB
Hi,
I've few phoenix tables created from Phoenix itself, they do fine with the
Phoenix, however, when I try to scan the data from hbase shell, the binary
strings get printed instead of the real values, like the one I can see in
the phoenix.
Also, there are cases when I want to fetch them directly
ng in Phoenix. So it
> operates with binary arrays. HBase shell shows printable ASCII characters
> as is and hex values for the rest. You may use spark-phoenix module to work
> with Phoenix from Spark.
>
> Thanks,
> Sergey
>
> On Thu, Nov 30, 2017 at 11:22 PM, Vaghawan Ojha
>
it only contains one value, is the same procedure.
>
> I hope this helps,
> Jacobo Coll
>
>
> 2017-12-04 11:25 GMT+00:00 Vaghawan Ojha :
>
>> Thank you very much for the response, it helps. So I'm guessing there is
>> no way to read the data from hbase directly which
Hi,
I'm facing a weird problem with queryserver. When I start the queryserver,
the log says that the service is listening in the port 8765, everything
looks fine.
But when I try to use the queryserver, the error like this prompts up.
n$ python sqlline-thin.py localhost:8765
Failed to extract ser
e to any specific line of code.
>
> Do you have a stacktrace in the PQS log? I'm not sure the the message is
> implying that "localhost" is being interpreted as a class name or if it's
> saying the PQS at localhost had an error. The more details you can provide,
> th
a:203)
> at sqlline.Commands.close(Commands.java:906)
> at sqlline.Commands.closeall(Commands.java:880)
> at sqlline.SqlLine.begin(SqlLine.java:714)
> at sqlline.SqlLine.start(SqlLine.java:398)
> at sqlline.SqlLine.main(SqlLine.java:291)
> at org.apache.phoenix.queryserver.clien
I've the same problem, even after I increased the hbase.rpc.timeout the
result is same. The difference is that I use 4.12.
On Thu, Feb 1, 2018 at 8:23 PM, Flavio Pompermaier
wrote:
> Hi to all,
> I'm trying to use the brand-new Phoenix 4.13.2-cdh5.11.2 over HBase and
> everything was fine until
Hi,
I'm using phoenix 4.12 with hbase 1.2.0, I've a table with few millions of
rows, but I don't need much of the old data, Let's say the frequent data I
need is data from 2 month back.
the query become slow when I read the table using timestamp. So query would
be like where date>some date and
.html
> [2] https://phoenix.apache.org/language/index.html#alter
> [3] https://phoenix.apache.org/rowtimestamp.html
>
> On Tue, Feb 13, 2018 at 2:42 AM, Vaghawan Ojha
> wrote:
>
>> Hi,
>>
>> I'm using phoenix 4.12 with hbase 1.2.0, I've a table with few mil
, Feb 14, 2018 at 7:47 AM, James Taylor
wrote:
> If the date time column is part of your pk, then you’d be able to use the
> ROW_TIMESTAMP feature.
>
> On Tue, Feb 13, 2018 at 5:04 PM Vaghawan Ojha
> wrote:
>
>> Yes, the datetime column is part of my primary key, but prim
Ok, Thank you very much for the help.
On Wed, Feb 14, 2018 at 12:43 PM, James Taylor
wrote:
> No, you’ll need to create a Phoenix table and use Phoenix APIs to write
> your data.
>
> On Tue, Feb 13, 2018 at 9:52 PM Vaghawan Ojha
> wrote:
>
>> Thank you James, my keys
18 matches
Mail list logo