How to extract data from hive effectively

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

What does the ORC SERDE do

Hello,everyone I know the json serde turn fields in a row to a json format, csv serde turn it to csv format with their serdeproperties. But I wonder what the orc serde does when I choose to stored as orc file format. And why is there still escaper, separator in orc serdeproperties. Also with

Re: What does the ORC SERDE do

ough it sounds complex, hive provides most of the functionality so > implementing a serde is most of the times easy. > >> On 13. May 2018, at 16:34, 侯宗田 <zongtian...@icloud.com> wrote: >> >> Hello,everyone >> I know the json serde turn fields in a row to a json

Does one table only have one hdfs directory

Hello, Hive table is stored in the path of hive.metastore.warehouse.dir, is one table only have one path, or it might have multiple directories?

Re: How to extract data from hive effectively

Thank you, > 在 2018年4月28日，下午11:09，Johannes Alberti <johan...@altiscale.com> 写道： > > sqoop 1.x ...sqoop export -connect ... > > Sent from my iPhone > >> On Apr 28, 2018, at 4:29 AM, 侯宗田 <zongtian...@icloud.com> wrote: >> >> Does anyone know

Hcatalog respond very slow

Hello,I am writing a application which needs the metastore in hive. I am preparing to use webhcat to get the information about tables and process them. But a simple request takes over eight seconds to respond on localhost. Why is this so slow, and how can I fix it? $ time curl -s

Hive can't be installed properly

Hi, I have git clone hive from the master branch and installed it by Maven, but always get the following error, does anyone what is going on here? [INFO] Running org.apache.hadoop.hive.metastore.conf.TestMetastoreConf [ERROR] Tests run: 22, Failures: 2, Errors: 0, Skipped: 0, Time elapsed:

Re: error when beeline connecting to hiveserver2

TEN) > java 33169 asinkovits 350u IPv6 0x 0t0 TCP > *:10002 (LISTEN) > > If it does, try > beeline -u jdbc:hive2://localhost:1 > > Regards, > Antal > > > On Tue, Apr 24, 2018 at 10:19 AM, 侯宗田 <zongtian...@icloud.com > <mail

error when beeline connecting to hiveserver2

Hi, I have started hiveserver2 and try to connect it with beeline using the following command: >!connect jdbc:hive2://localhost:10002/default But get the following error WARN jdbc.HiveConnection: Failed to connect to localhost:10002 Unknown HS2 problem when communicating with Thrift server.