+1, This would be a useful addition, especially for workflows involving temporary datasets.
Best, Suryaa On Thu, Mar 13, 2025 at 1:18 PM Ian Maxon <ima...@apache.org> wrote: > +1 > > On Mar 13, 2025 at 13:14:03, Ayush Kumar Tripathi > <ayush.tripa...@couchbase.com.invalid> wrote: > > > Hi All , > > > > Initiating a discussion to propose Truncate Statement support in > AsterixDB. > > *Feature:* Adding truncate dataset support in AsterixDB. > > *Details:* Currently, AsterixDB lacks support for the TRUNCATE statement, > > which limits the ability to efficiently remove all records from a dataset > > without dropping and recreating it. This proposed feature would enable > > users to quickly and safely delete all data within a dataset while > > preserving its schema. > > > > APE: > > > https://urldefense.com/v3/__https://cwiki.apache.org/confluence/display/ASTERIXDB/APE*19*3A*TRUNCATE*statement__;KyUrKw!!CzAuKJ42GuquVTTmVmPViYEvSg!Jt7rk7aHrCvhHXVSGPoIpvgBusrCYOxK44mKjV3ceweTatF3NPj-L-gvq1YDBSrmWkA6ZfLq4QeImphTg_9E2w5VrWQ2ludl$ > > > > Regards, > > Ayush > > >
