GitHub user bellwether-softworks closed a discussion: Idiomatic DML/CRUD?
Sorry, I'm not quite sure how to frame that title, but in a nutshell, as my
data changes I frequently find myself having to tear down and replace data
wholesale. My current pattern is basically:
1. `ctx.deregister_table("my_first_table")`
2. Create new `MemTable` using latest dataset
3. `ctx.register_table("my_first_table", Arc::new(mem_table))?`
Incidentally, this works for me for most cases, since a lot of my data is
static, but there are some datasets I am frequently modifying, and it feels
"wasteful" to have to scrap entire tables if all I'm doing is deleting or
modifying the occasional record.
Am I looking at this wrong? Is there a "better" way to handle basic CRUD
operations (including using the SQL interface); if not now, is it planned, or
am I misusing/abusing DF by trying to do this in the first place?
GitHub link: https://github.com/apache/datafusion/discussions/8585
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
