You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hawq.apache.org by jinzhy <ji...@neusoft.com> on 2016/07/13 02:10:12 UTC
A question of HAWQ
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.
---------------------------------------------------------------------------------------------------
Re: A question of HAWQ
Posted by Lei Chang <le...@apache.org>.
please see items on the roadmap page here:
https://cwiki.apache.org/confluence/display/HAWQ/HAWQ+Roadmap
Cheers
Lei
On Thu, Jul 14, 2016 at 8:44 AM, Paul Guo <pa...@gmail.com> wrote:
> HAWQ has not supported update and delete yet, but the feature is on the
> plan.
>
> 2016-07-13 23:13 GMT+08:00 Wales Wang <wo...@yahoo.com.invalid>:
>
> > HAWQ is append only.
> > Actian vectorH have full feature and index，update, delete
> >
> > Wales Wang
> >
> > 在 2016-7-13，上午10:10，jinzhy <ji...@neusoft.com> 写道：
> >
> > > 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.
> > >
> >
> ---------------------------------------------------------------------------------------------------
> >
>
Re: A question of HAWQ
Posted by Paul Guo <pa...@gmail.com>.
HAWQ has not supported update and delete yet, but the feature is on the
plan.
2016-07-13 23:13 GMT+08:00 Wales Wang <wo...@yahoo.com.invalid>:
> HAWQ is append only.
> Actian vectorH have full feature and index，update, delete
>
> Wales Wang
>
> 在 2016-7-13，上午10:10，jinzhy <ji...@neusoft.com> 写道：
>
> > 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.
> >
> ---------------------------------------------------------------------------------------------------
>
Re: A question of HAWQ
Posted by Wales Wang <wo...@yahoo.com.INVALID>.
HAWQ is append only.
Actian vectorH have full feature and index，update, delete
Wales Wang
在 2016-7-13，上午10:10，jinzhy <ji...@neusoft.com> 写道：
> 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.
> ---------------------------------------------------------------------------------------------------
Re: Fwd: A question of HAWQ
Posted by Ming Li <ml...@pivotal.io>.
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 <ji...@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 <ml...@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 <ji...@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.
>
> ---------------------------------------------------------------------------------------------------
>
Re: A question of HAWQ
Posted by Ming Li <ml...@pivotal.io>.
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 <ji...@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.
>
> ---------------------------------------------------------------------------------------------------
>