Re: How to extract data from hive effectively

Thank you, > 在 2018年4月28日，下午11:09，Johannes Alberti 写道： > > sqoop 1.x ...sqoop export -connect ... > > Sent from my iPhone > >> On Apr 28, 2018, at 4:29 AM, 侯宗田 wrote: >> >> Does anyone know how to extract data from hive to other databases >>

Re: Proposal: Apply SQL based authorization functions in the metastore.

Hi Elliot, One scenario where Storage based authorization doesn't work is the case of object stores such as S3. In those scenarios, the tool/platform that is accessing the data won't have any restrictions on data access either. I am not sure how the data access would be secured in such cases,

Re: How to extract data from hive effectively

sqoop 1.x ...sqoop export -connect ... Sent from my iPhone > On Apr 28, 2018, at 4:29 AM, 侯宗田 wrote: > > Does anyone know how to extract data from hive to other databases > effectively, like hawq etc. > > 发自我的 iPhone

Re: Hive External Table with Zero Bytes files

Your external table is referencing the .../day=201803250 location which is empty. Point your table to the capital .../DAY=201803250 and you should be able to read the data there. Also, it looks like you want external partitioned table. You’ll need to create an external table with a partition

How to extract data from hive effectively

Does anyone know how to extract data from hive to other databases effectively, like hawq etc. 发自我的 iPhone

Re: Hive External Table with Zero Bytes files

Gentle Ping. Please help me on below issue. Has any one faced same issue On 4/27/2018 1:28 AM, Mahender Sarangam wrote: Hi, Can any one faced issue while fetching data from external table. We are copying data from upstream system into our storage S3. As part of copy, directories along with