Please see the following which went to Hive 1.1 :
HIVE-8839 Support "alter table .. add/replace columns cascade"
FYI
On Mon, Nov 30, 2015 at 2:14 PM, Daniel Lopes <dan...@bankfacil.com.br>
wrote:
> Hi,
>
> I get this error when trying to write Spark DataFrame to Hive Table Stored
> as TextFile
>
>
> sqlContext.sql('INSERT OVERWRITE TABLE analytics.client_view_stock *(hive
> table)* SELECT * FROM client_view_stock'*(spark temp table)*')
>
> Erro:
>
> 15/11/30 21:40:14 INFO latency: StatusCode=[404],
> Exception=[com.amazonaws.services.s3.model.AmazonS3Exception: Not Found
> (Service: Amazon S3; Status Code: 404; Error Code: 404 Not Found; Request
> ID: 5ADBECA2D82A7C17), S3 Extended Request ID:
> RcPfjgWaeXG62xyVRrAr91sVQNxktqbXUPJgK2cvZlf6SKEAOnWCtV9X9K1Vp9dAyDhGALQRBcU=],
> ServiceName=*[Amazon S3], AWSErrorCode=[404 Not Found]*,
> AWSRequestID=[5ADBECA2D82A7C17], ServiceEndpoint=[
> https://my-bucket.s3.amazonaws.com], Exception=1,
> HttpClientPoolLeasedCount=0, RequestCount=1, HttpClientPoolPendingCount=0,
> HttpClientPoolAvailableCount=1, ClientExecuteTime=[214.69],
> HttpRequestTime=[214.245], HttpClientReceiveResponseTime=[212.513],
> RequestSigningTime=[0.16], HttpClientSendRequestTime=[0.112],
> 15/11/30 21:40:21 INFO Hive: Replacing
> src:s3://my-bucket/output/2015/11/29/client_view_stock/.hive-staging_hive_2015-11-30_21-19-48_942_238078420083598647-1/-ext-10000/part-00199,
> dest: s3://my-bucket/output/2015/11/29/client_view_stock/part-00199,
> Status:true
> -chgrp: '' does not match expected pattern for group
> Usage: hadoop fs [generic options] -chgrp [-R] GROUP PATH...
> 15/11/30 21:40:21 INFO latency: StatusCode=[200], ServiceName=[Amazon S3],
> AWSRequestID=[2509AE55A8D71A61], ServiceEndpoint=[https://my-bucket.
> s3.amazonaws.com], HttpClientPoolLeasedCount=0, RequestCount=1,
> HttpClientPoolPendingCount=0, HttpClientPoolAvailableCount=1,
> ClientExecuteTime=[137.387], HttpRequestTime=[136.721],
> HttpClientReceiveResponseTime=[134.805], RequestSigningTime=[0.235],
> ResponseProcessingTime=[0.169], HttpClientSendRequestTime=[0.145],
> 15/11/30 21:40:21 WARN RetryingMetaStoreClient: MetaStoreClient lost
> connection. Attempting to reconnect.
> org.apache.thrift.TApplication*Exception: Invalid method name:
> 'alter_table_with_cascade'*
>
> Thanks!
>
> --
> *Daniel Lopes, B.Eng*
> Data Scientist - BankFacil
> CREA/SP 5069410560
> <http://edital.confea.org.br/ConsultaProfissional/cartao.aspx?rnp=2613651334>
> Mob +55 (18) 99764-2733 <callto:+5518997642733>
> Ph +55 (11) 3522-8009
> http://about.me/dannyeuu
>
> Av. Nova Independência, 956, São Paulo, SP
> Bairro Brooklin Paulista
> CEP 04570-001
> https://www.bankfacil.com.br
>
>
