Re: LINES TERMINATED BY only supports newline '\n' right now

2016-06-02 Thread Peter Vary
Hi, According to the documentation you should write and set your own Inputformat when creating the table. Mike Sukmanowsky solved a similar problem here, this might help you: http://stackoverflow.com/questions/7692994/custom-inputformat-with-hive Regards, Peter For some of the columns '\n'

Re: [ANNOUNCE] New PMC Member : Jesus

2016-07-18 Thread Peter Vary
Congratulations Jesus! > On Jul 18, 2016, at 6:55 AM, Wei Zheng wrote: > > Congrats Jesus! > > Thanks, > > Wei > > > > > > > > On 7/17/16, 14:29, "Sushanth Sowmyan" wrote: > >> Good to have you onboard, Jesus! :) >> >> On Jul 17, 2016

Re: [ANNOUNCE] New PMC Member : Pengcheng

2016-07-18 Thread Peter Vary
Congratulations Pengcheng! > On Jul 18, 2016, at 6:55 AM, Wei Zheng wrote: > > Congrats Pengcheng! > > Thanks, > > Wei > > > > > > > On 7/17/16, 16:01, "Xuefu Zhang" wrote: > >> Congrats, PengCheng! >> >> On Sun, Jul 17, 2016 at 2:28 PM,

Re: [Announce] New Hive Committer - Mohit Sabharwal

2016-07-01 Thread Peter Vary
Congratulations Mohit! 2016. júl. 1. 19:10 ezt írta ("Vihang Karajgaonkar" ): > Congratulations Mohit! > > > On Jul 1, 2016, at 10:05 AM, Chao Sun wrote: > > > > Congratulations Mohit! Good job! > > > > Best, > > Chao > > > > On Fri, Jul 1, 2016 at 9:57 AM,

Re: Can I specify database name in hive metastore service?

2016-10-25 Thread Peter Vary
Hi Huang, Hive metastore is a component of the "Hive database". See: https://cwiki.apache.org/confluence/display/Hive/Design The metastore uses traditional RDBMS to store "the structure information of the various tables and partitions in the warehouse". The javax.jdo.option.ConnectionURL and the

Re: Can I specify database name in hive metastore service?

2016-10-26 Thread Peter Vary
meta data is isolated form each other. How can I achieve > that? > > > > 发件人: Peter Vary <pv...@cloudera.com> > 发送时间: 2016年10月26日 0:49 > 收件人: user@hive.apache.org > 主题: Re: Can I specify database name in hive metastore service? > > Hi Huang, > Hive met

Re: [ANNOUNCE] New Hive Committer - Rajesh Balamohan

2016-12-15 Thread Peter Vary
Congratulations Rajesh! > On Dec 15, 2016, at 6:40 AM, Rui Li wrote: > > Congratulations :) > > On Thu, Dec 15, 2016 at 6:50 AM, Gunther Hagleitner < > ghagleit...@hortonworks.com> wrote: > >> Congrats Rajesh! >> >> From: Jimmy

Re: operation log is missing when using hive.execution.engine=mr

2017-05-15 Thread Peter Vary
Hi Jessica, Is it possible that you are effected by this? https://issues.apache.org/jira/browse/HIVE-16061 Thanks, Peter 2017. máj. 15. 19:44 ezt írta ("Jie Zhang" ): Hi, My team just upgrade Hive from 0.14.0 to 2.1.1. The operation log is missing when running the

Re: Welcome Rui Li to Hive PMC

2017-05-25 Thread Peter Vary
Congratulations Rui! > On May 25, 2017, at 6:19 AM, Xuefu Zhang wrote: > > Hi all, > > It's an honer to announce that Apache Hive PMC has recently voted to invite > Rui Li as a new Hive PMC member. Rui is a long time Hive contributor and > committer, and has made significant

Re: Jimmy Xiang now a Hive PMC member

2017-05-25 Thread Peter Vary
Congratulations Jimmy! > On May 25, 2017, at 6:16 AM, Xuefu Zhang wrote: > > Hi all, > > It's an honer to announce that Apache Hive PMC has recently voted to invite > Jimmy Xiang as a new Hive PMC member. Please join me in congratulating him > and looking forward to a

Re: Welcome new Hive committer, Zhihai Xu

2017-05-05 Thread Peter Vary
Congratulations Zhihai! 2017. máj. 5. 18:52 ezt írta ("Xuefu Zhang" ): > Hi all, > > I'm very please to announce that Hive PMC has recently voted to offer > Zhihai a committership which he accepted. Please join me in congratulating > on this recognition and thanking him for his

Re: A misspelling about hive.server2.webui.use.spnego

2018-06-07 Thread Peter Vary
Hi, That was a documentation error. Fixed it. Thanks for reporting Kylin Jin! Peter > On Jun 7, 2018, at 9:12 AM, Kylin Jin wrote: > > hi > In Hive Configuration Properties: > > https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties >

Re: Alter table using Thrift client

2018-07-11 Thread Peter Vary
Hi Sylvester, You can set this specific configuration value per session since HIVE-17832 - Fixed in: Hive 3.0.0, Hive 2.4.0 So you can do this change this value through thrift if your metastore version is higher or equal than 2.4.0, or 3.0.0, but not with 1.2.1 If you want to use 1.2.1

Re: Alter table using Thrift client

2018-07-11 Thread Peter Vary
t; hive.metastore.disallow.incompatible.col.type.changes) > > Am I not setting the property correctly, or will I have to upgrade the hive > server to version 2.4/3.0 as well? > > Thanks! > > On Wed, Jul 11, 2018 at 4:56 AM, Peter Vary <mailto:pv...@cloudera.com>> w

Re: Alter table using Thrift client

2018-07-12 Thread Peter Vary
wrote: > > Hi Peter, > > client.setMetaConf("metastore.disallow.incompatible.col.type.changes", > "false") gets me the same error: > > MetaException(message:Invalid configuration key > metastore.disallow.incompatible.col.type.changes) > > Thanks > > On Wed, Jul 11, 2018 at

Re: UDFJson cannot Make Progress and Looks Like Deadlock

2018-07-24 Thread Peter Vary
Hi Guizhou, I would guess, that this is caused by: HIVE-16196 UDFJson having thread-safety issues Try to upgrade to a CDH version where this patch is already included (5.12.0 or later) Regards, Peter > On Jul 24, 2018, at 10:15, Proust

Re: UDFJson cannot Make Progress and Looks Like Deadlock

2018-07-25 Thread Peter Vary
his out, it makes the problem clear. > > > For a quick workaround and low cost without upgrading, I'm considering > to reimplement the UDF get_json_object to a new name to avoid the problem. > > > > Thanks > Guizhou > -- > *From:* Peter Vary &