Re: Count bug in Hive 3.0.0.3.1

2020-04-28 Thread Tim Havens
Unsubscribe On Tue, Apr 28, 2020, 1:23 AM Deepak Krishna wrote: > Hi team, > > We came across a bug related to count function. We are using hive > 3.0.0.3.1 with Tez 0.9.0.3.1. PFA the queries to replicate the issue. > > Please register this as a bug and let us know if we can support in anyway >

Re: Permissions preventing me from inserting data into table I have just created

2012-11-26 Thread Tim Havens
make sure :/home/yaboulnaga/tmp/**hive-scratch/ is writeable by your processes. On Mon, Nov 26, 2012 at 10:07 AM, wrote: > Hello, > > I'm using Cloudera's CDH4 with Hive 0.9 and Hive Server 2. I am trying to > load data into hive using the JDBC driver (the one distributed with > Cloudera CDH4 "

Re: Long running Join Query - Reduce task fails due to failing to report status

2012-08-24 Thread Tim Havens
Just curious if you've tried using Hive's explain method to see what IT thinks of your query. On Fri, Aug 24, 2012 at 9:36 AM, Himanish Kushary wrote: > Hi, > > We have a complex query that involves several left outer joins resulting > in 8 M/R jobs in Hive.During execution of one of the stages

Re: How to list all views

2012-07-05 Thread Tim Havens
There may be a way to select table_name's from the metastore...if so name your views like *_view and select for those table names. Of course if you can query the metastore there's probably an even better way where you don't have to name you view's anything special, and just search for a table type

Re: How to override a property with in a hive query

2012-07-03 Thread Tim Havens
What are you trying to accomplish that a method like this won't work for? On Mon, Jul 2, 2012 at 10:25 PM, Abhishek wrote: > Hi Tim, > > Is this the only way, or if we have any other ways. > > Sent from my iPhone > > On Jul 2, 2012, at 8:49 PM, Tim Havens wrote: >

Re: How to override a property with in a hive query

2012-07-02 Thread Tim Havens
Before your query type SET = ; On Mon, Jul 2, 2012 at 7:13 PM, Abhishek wrote: > Hi all, > > Can I know, how to override a property of mapred-site.xml in Hive join > query. > Suppose for map reduce job we override using -D , how > to do it with in hive query. > > Regards > Abhishek. > > > Begin

Re: Please HELP: HIVE alter table add new partition to schema...

2012-06-19 Thread Tim Havens
are running into the small files problem, there are other ways to get > around like bucketing. > > Good luck! > Mark > > - Original Message ----- > From: "Edward Capriolo" > To: user@hive.apache.org > Sent: Tuesday, June 19, 2012 11:12:48 AM > Subject:

Please HELP: HIVE alter table add new partition to schema...

2012-06-19 Thread Tim Havens
So...I have a table that has thousands of files, and Billions of rows related it. Lets make this a simple table: CREATE TABLE test_table ( ts BIGINT, exec_time DOUBLE, domain_id BIGINT, domain_name STRING, ) PARTITIONED BY (logdate STRING, source STRING, datacenter STRING, hostnam

Re: Order by Sort by partitioned columns

2012-05-16 Thread Tim Havens
I frequently sort by partitioned columns, without issues. Post your table schema, and your query that's failing, lets see what's going on? Tim On Mon, May 14, 2012 at 1:28 AM, Shin Chan wrote: > Hi All > > Just curious if its possible to Order by or Sort by partitioned columns. > > I tried it

Re: FAILED: Execution Error, return code -101 from org.apache.hadoop.hive.ql.exec.FunctionTask

2012-01-22 Thread Tim Havens
lang.ClassLoader.loadClass(ClassLoader.java:266) ... 18 more FAILED: Execution Error, return code -101 from org.apache.hadoop.hive.ql.exec.FunctionTask On Sun, Jan 22, 2012 at 3:43 PM, Tim Havens wrote: > Unfortunately the issue appears to be something with the Jar, or my UDF. > > What

Re: FAILED: Execution Error, return code -101 from org.apache.hadoop.hive.ql.exec.FunctionTask

2012-01-22 Thread Tim Havens
h for you I guess. After that you can directly create temporary function > in hive. > > ~Aniket > > > On Sun, Jan 22, 2012 at 1:24 PM, Aniket Mokashi wrote: > >> Add the jar to HADOOP_CLASSPATH when you launch hive. That should help. >> >> Thanks, >> Ani

FAILED: Execution Error, return code -101 from org.apache.hadoop.hive.ql.exec.FunctionTask

2012-01-22 Thread Tim Havens
I have a similar UDF to this one which create's just fine. I cam seem to resolve what 'return code -101' means however with this one. Can anyone tell me what 'return code -101' means? My StemTermsUDF.jar has the proper classpath for the JWNL jars already, I'm trying to insure they've REALLY avai