hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ming Li <...@pivotal.io>
Subject Re: Fwd: A question of HAWQ
Date Fri, 15 Jul 2016 03:19:13 GMT
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 <jinzhy@neusoft.com> 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 <mli@pivotal.io>
> *Date:* 2016-07-15 10:26
> *To:* jinzhy@neusoft.com
> *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 <jinzhy@neusoft.com> 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.
>
> ---------------------------------------------------------------------------------------------------
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message