AFAIK, autoCommit should be working in that version with PQS.
Did you try James' suggestion of calling !commit?
On Fri, Apr 28, 2017 at 6:04 PM, Michael Young wrote:
> Update:
>
> The delete issue happens when I connect via the Phoenix Query Server but
> works fine when I connect to the phoenix
Update:
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/2.5.0.0-1245/phoenix/bin/sqlline-thin.py http://mypqs:8765
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' fa
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
