Re: Rlike '\s' couldn't get the space

2018-11-14 Thread Tanvi Thacker
Hi, You need to use "*rlike '\\s' * to escape the single backslash. Regards Tanvi Thacker On Mon, Nov 12, 2018 at 3:02 AM anci_...@yahoo.com wrote: > Dears, > I see that using '\s' can get the whitespace character in normal java > regular expressions,

Re: Can not do insert query error code -101

2018-10-31 Thread Tanvi Thacker
in the classpath and keep the one which is shipped with Hive 3.0 only. Regards Tanvi Thacker On Sat, Oct 27, 2018 at 5:50 AM ZongtianHou wrote: > Hi, everyone, > I have installed hive3.0 and tried it. I created a table , but can’t > insert a record into it. Below is the operation

Re: Question about INSERT OVERWRITE TABLE with dynamic partition

2018-10-24 Thread Tanvi Thacker
query, Dynamic partition step needs to deduce partition name from the query result, but as your query is not producing any row, there is no info of the partition to take action on. Regards, Tanvi Thacker On Tue, Oct 23, 2018 at 9:38 PM anci_...@yahoo.com wrote: > Dears, > I fo

Re: Unable to query remote hive metastore

2018-10-24 Thread Tanvi Thacker
I'm not sure but when you need to make a remote connection, you may try using the filesystem confs(hdfs-site.xml and core-site.xml) of remote DFS(hadoop-1xx:9000) in the classpath of hive client of cluster(ds-1xx)(remember to exclude the local hdfs-site.xml and core-site.xml) Regards

Re: Enabling Snappy compression on Parquet

2018-08-21 Thread Tanvi Thacker
essed table as select * from un_compressed_table" in order to actually compress the data Regards, Tanvi Thacker On Fri, Aug 10, 2018 at 6:30 AM Patrick Duin wrote: > Hi, > > I got some hive tables in Parquet format and I am trying to find out how > best to enable compression. >

Re: About Hive create table

2018-08-21 Thread Tanvi Thacker
184 seconds Regards, Tanvi Thacker On Thu, Aug 9, 2018 at 4:06 AM xujund...@163.com wrote: > Hi Apache org: > Recently I found a very interesting question, I don't know is a bug > or design flaws. > 最近我发现了一个有趣的问题,不知道是bug还是设计的漏洞。 > When creating internal table, pl

Re: Hook is not getting called on running query from beeline

2018-08-21 Thread Tanvi Thacker
like this beeline -u "jdbc:hive2://example.com:2181,example.com:2181,example:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2" *--hiveconf hive.exec.post.hooks=* Regards, Tanvi Thacker On Tue, Aug 21, 2018 at 9:00 AM Chetan Kothari wrote: > Any inputs on following

Re: Unable to access hive views

2018-08-21 Thread Tanvi Thacker
Can you please check your task logs of the job and please share the stack trace you see from there. Regards, Tanvi Thacker On Thu, Aug 2, 2018 at 9:11 PM Satish Karuturi wrote: > I am trying to access the views in Hive, getting following Exception: > > Error: Error while processing

Re: Does Hive 3.0 only works with hadoop3.x.y?

2018-07-21 Thread Tanvi Thacker
which hive is compiled and tested. https://github.com/apache/hive/blob/rel/release-3.0.0/pom.xml#L149 Thanks, Tanvi Thacker On Thu, Jul 19, 2018 at 8:15 PM, Sungwoo Park wrote: > I would say yes (because I am actually running Hive 3.0 on Hadoop 2.7.6 > and HDP 2.7.5), provided that you make