phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Young <>
Subject Re: Unable to delete from table
Date Fri, 28 Apr 2017 22:04:22 GMT

The delete issue happens when I connect via the Phoenix Query Server but
works fine when I connect to the phoenix client on port 2181 (I was able to
delete all records).  Auto-commit is true.

Here's what I see with PQS:

/usr/hdp/ http://mypqs:8765

Setting property: [incremental, false]
Setting property: [isolation, TRANSACTION_READ_COMMITTED]
issuing: !connect
none none org.apache.phoenix.queryserver.client.Driver
Connecting to
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in
SLF4J: Found binding in
SLF4J: See for an
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
Connected to: Apache Phoenix (version unknown version)
Driver: Phoenix Remote JDBC Driver (version unknown version)
Autocommit status: true
Building list of tables and columns for tab-completion (set fastconnect to
true to skip)...
7815/7815 (100%) Done
sqlline version 1.1.8

On Fri, Apr 28, 2017 at 1:13 PM, James Taylor <>

> Did you commit the data? I'd recommend turning auto commit on for the
> connection before running the delete statement.
> Thanks,
> James
> On Fri, Apr 28, 2017 at 12:36 PM, Michael Young <>
> wrote:
>> This is probably a newbie question, but has anyone run across a case
>> where a simple 'delete from tbl' fails to work?
>> my_tmp_table has 29,728 rows
>> I run:
>> delete from my_tmp_table;
>> 29,728 rows affected (0.08 seconds)
>> select count(*) from my_tmp_table;
>> 'COUNT(1)'
>> '29728'
>> No rows were deleted from this table.  My table doesn't have
>> IMMUTABLE_ROWS=true, but even if it did I would expect delete to work.
>> We use phoenix- in HDP 2.5 release.
>> Are there any checks I can do to identify the cause (without restarting
>> hbase, that is)?
>> -Michael

View raw message