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, yabou...@uwaterloo.ca 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

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 himan...@gmail.comwrote: Hi, We have a complex query that involves several left outer joins resulting in 8 M/R jobs in Hive.During execution of one

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

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 abhishek.dod...@gmail.com 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 timhav...@gmail.com

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

2012-07-02 Thread Tim Havens
Before your query type SET property = blah; On Mon, Jul 2, 2012 at 7:13 PM, Abhishek abhishek.dod...@gmail.com 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 property name=value, how to do it with

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,

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

2012-06-19 Thread Tim Havens
the partition columns. I would use a dynamic partition insert to select all the data from the original table into the new table. On 6/19/12, Tim Havens timhav...@gmail.com wrote: So...I have a table that has thousands of files, and Billions of rows related it. Lets make this a simple table

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 had...@gmx.com wrote: Hi All Just curious if its possible to Order by or Sort by partitioned columns. I

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

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

2012-01-22 Thread Tim Havens
AM, Tim Havens timhav...@gmail.com wrote: 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