Thanks jinzhy. This is a big feature, HDFS cannot support update/delete, all other DB declare supporting it as a tricky workaround which severely affect SELECT performance. We need more investigation for it.
On Fri, Jul 15, 2016 at 10:49 AM, jinzhy <[email protected]> wrote: > I think just like HBASE is OK，users can delete or update data if they > want. The operator may be not used very frequently, but when users find > data they copy into HAWQ is changed , they can update or delete it instead > of truncate the whole table, this feature is more convenient for us. > > Compacting of HBASE and Vacuum of postgresql are very similar in my > opinion. So I think is not very difficult to HAWQ. > > > > > *From:* Ming Li <[email protected]> > *Date:* 2016-07-15 10:26 > *To:* [email protected] > *Subject:* Fwd: A question of HAWQ > Hi jinzhy, > > We are planning on this feature. It is a big feature which will definitely > affect the SELECT performance. > > I would like to know the scenario you want 'DELETE' or 'UPDATE', > especially the row number affected, and the frequency these operator > request. It will very useful for us to think about the implementation > details about this feature. > > Thanks. > > On Wed, Jul 13, 2016 at 10:10 AM, jinzhy <[email protected]> wrote: > >> hello everybody， >> >> Can HAWQ or Pivotal HD support 'delete' or 'update' operation in >> HDFS now？I can only create append only table in my computer。 >> >> >> >> >> >> >> >> >> >> --------------------------------------------------------------------------------------------------- >> Confidentiality Notice: The information contained in this e-mail and any >> accompanying attachment(s) >> is intended only for the use of the intended recipient and may be >> confidential and/or privileged of >> Neusoft Corporation, its subsidiaries and/or its affiliates. If any >> reader of this communication is >> not the intended recipient, unauthorized use, forwarding, printing, >> storing, disclosure or copying >> is strictly prohibited, and may be unlawful.If you have received this >> communication in error,please >> immediately notify the sender by return e-mail, and delete the original >> message and all copies from >> your system. Thank you. >> >> --------------------------------------------------------------------------------------------------- >> > > > > > --------------------------------------------------------------------------------------------------- > Confidentiality Notice: The information contained in this e-mail and any > accompanying attachment(s) > is intended only for the use of the intended recipient and may be > confidential and/or privileged of > Neusoft Corporation, its subsidiaries and/or its affiliates. If any reader > of this communication is > not the intended recipient, unauthorized use, forwarding, printing, > storing, disclosure or copying > is strictly prohibited, and may be unlawful.If you have received this > communication in error,please > immediately notify the sender by return e-mail, and delete the original > message and all copies from > your system. Thank you. > > --------------------------------------------------------------------------------------------------- >
