Reading through the documentation --> http://snappydatainc.github.io/snappydata/rowAndColumnTables/#row-and-column-tables
I see that we should be able to perform DELETE FROM .... sql statements against row and column tables. I am seeing inconsistent results when attempting to delete from a column table.
Here is my table:
CREATE TABLE MY_TABLE_COL (
w_id VARCHAR(64),
name VARCHAR(128),
my_time TIMESTAMP,
value VARCHAR(128),
year_num INTEGER,
month_num INTEGER
)
USING column
OPTIONS(PARTITION_BY 'year_num, month_num', BUCKETS '113', PERSISTENT 'ASYNCHRONOUS');
Here is an example delete statement:
DELETE FROM MY_TABLE_COL where my_time >= '2016-08-10 00:00:00'
I've been attempting this query from Squirrel SQL and from the snappy-shell. Sometimes a portion of the records I expect to be deleted will actually be deleted. Other times, ZERO records are deleted.
I can wipe out all the data using the TRUNCATE TABLE MY_TABLE_COL command, but this will not work long term as we need to be able to selectively delete from a table.
Any help is appreciated!
Supporting updates and deletes on column tables is on our roadmap but currently they are not supported. Updates and deletes are however supported on row tables.
For the inconsistencies that you are seeing, I have created two JIRAs.