n Fri, Jun 1, 2012 at 9:31 PM, sagar naik wrote:
>
>> I am using hive-0.7-cdh3u0
>>
>> Thanks Again
>>
>> On Fri, Jun 1, 2012 at 9:20 PM, sagar naik wrote:
>> > Hi ,
>> > I am seeing a very weird hive-hbase query behaviour.
>> > I have an e
I am using hive-0.7-cdh3u0
Thanks Again
On Fri, Jun 1, 2012 at 9:20 PM, sagar naik wrote:
> Hi ,
> I am seeing a very weird hive-hbase query behaviour.
> I have an externally mounted hbase table in hive
>
>
> select creation_ts, length(url), isnull(url), ! (isnull(url)) from
Hi ,
I am seeing a very weird hive-hbase query behaviour.
I have an externally mounted hbase table in hive
select creation_ts, length(url), isnull(url), ! (isnull(url)) from
task_table limit 10;
Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no
t; You'll need a subquery to enforce that condition. Alternatively, adding ' OR
> T2.field6 IS NULL' might work for you too. Just make sure to use parens
> around the OR clause. But that's probably not what you want - then, use a
> subquery.
>
>
>
> On Fri
Hi ,
I am trying to do join on same table.
I wanted to do a left outer join
However, the results are not like left outer join( with no null values)
select T1.field1, T1.field2, T1.field3
T2.field10
from table T1
left outer join table T2 on (T1.key=T2.key and
T1.parti
);
>
> //sl.getRecordCount()
> fieldNames.add("cCount");
>
> fieldInspectors.add(PrimitiveObjectInspectorFactory.javaLongObjectInspector);
>
> StructObjectInspector soi =
> ObjectInspectorFactory.ge
Hi ,
I have a four column external table.
One of the col is array of struct of five fields.
I use a custom serde, to read out hadoop seq file and populate values on to
hive row.
The array of struct is ArrayList of Object[5].
All queries run fine.
Except the explode query which gives a class cast
