回复：Re: how to delete data from table in sparksql

[luohui20001]

got it,thank you.




 

Thanks&Best regards!
San.Luo

- 原始邮件 -
发件人：Michael Armbrust 
收件人：Denny Lee 
抄送人：罗辉 , user 
主题：Re: how to delete data from table in sparksql
日期：2015年05月15日 01点49分

The list of unsupported hive features should mention that it implicitly 
includes features added after Hive 13.  You cannot yet compile with Hive > 13, 
though we are investigating this for 1.5
On Thu, May 14, 2015 at 6:40 AM, Denny Lee  wrote:
Delete from table is available as part of Hive 0.14 (reference: Apache Hive > 
Language Manual DML - Delete) while Spark 1.3 defaults to Hive 0.13.Perhaps 
rebuild Spark with Hive 0.14 or generate a new table filtering out the values 
you do not want.  

On Thu, May 14, 2015 at 3:26 AM  wrote:
Hi guys   i got to delete some data from a table by "delete from table 
where name = xxx", however "delete" is not functioning like the DML operation 
in hive.  I got a info like below:Usage: delete [FILE|JAR|ARCHIVE]  
[]*
15/05/14 18:18:24 ERROR processors.DeleteResourceProcessor: Usage: delete 
[FILE|JAR|ARCHIVE]  []*

   I checked the list of "Supported Hive Features" , but not found if this 
dml is supported.   So any comments will be appreciated.



 

Thanks&Best regards!
San.Luo

Re: how to delete data from table in sparksql

[Michael Armbrust]

The list of unsupported hive features should mention that it implicitly
includes features added after Hive 13.  You cannot yet compile with Hive >
13, though we are investigating this for 1.5

On Thu, May 14, 2015 at 6:40 AM, Denny Lee  wrote:

> Delete from table is available as part of Hive 0.14 (reference: Apache
> Hive > Language Manual DML - Delete
> )
> while Spark 1.3 defaults to Hive 0.13.Perhaps rebuild Spark with Hive
> 0.14 or generate a new table filtering out the values you do not want.
>
> On Thu, May 14, 2015 at 3:26 AM  wrote:
>
>> Hi guys
>>
>>i got to delete some data from a table by "delete from table where
>> name = xxx", however "delete" is not functioning like the DML operation in
>> hive.  I got a info like below:
>>
>> Usage: delete [FILE|JAR|ARCHIVE]  []*
>>
>> 15/05/14 18:18:24 ERROR processors.DeleteResourceProcessor: Usage: delete
>> [FILE|JAR|ARCHIVE]  []*
>>
>>
>>
>>I checked the list of "Supported Hive Features" , but not found
>> if this dml is supported.
>>
>>So any comments will be appreciated.
>>
>> 
>>
>> Thanks&Best regards!
>> San.Luo
>>
>

Re: how to delete data from table in sparksql

[Denny Lee]

Delete from table is available as part of Hive 0.14 (reference: Apache Hive
> Language Manual DML - Delete
)
while Spark 1.3 defaults to Hive 0.13.Perhaps rebuild Spark with Hive
0.14 or generate a new table filtering out the values you do not want.

On Thu, May 14, 2015 at 3:26 AM  wrote:

> Hi guys
>
>i got to delete some data from a table by "delete from table where
> name = xxx", however "delete" is not functioning like the DML operation in
> hive.  I got a info like below:
>
> Usage: delete [FILE|JAR|ARCHIVE]  []*
>
> 15/05/14 18:18:24 ERROR processors.DeleteResourceProcessor: Usage: delete
> [FILE|JAR|ARCHIVE]  []*
>
>
>
>I checked the list of "Supported Hive Features" , but not found if
> this dml is supported.
>
>So any comments will be appreciated.
>
> 
>
> Thanks&Best regards!
> San.Luo
>

how to delete data from table in sparksql

[luohui20001]

Hi guys   i got to delete some data from a table by "delete from table 
where name = xxx", however "delete" is not functioning like the DML operation 
in hive.  I got a info like below:Usage: delete [FILE|JAR|ARCHIVE]  
[]*
15/05/14 18:18:24 ERROR processors.DeleteResourceProcessor: Usage: delete 
[FILE|JAR|ARCHIVE]  []*

   I checked the list of "Supported Hive Features" , but not found if this 
dml is supported.   So any comments will be appreciated.



 

Thanks&Best regards!
San.Luo