Hi
CROSS JOIN is same as giving JOIN keyword. CROSS JOIN just a new notation in
later releases of hive. JOIN without ON is same as CROSS JOIN
Regards,
Bejoy KS
From: MiaoMiao
To: user@hive.apache.org
Sent: Friday, September 7, 2012 11:46 AM
Subject: Re: How
Hi Users,
Please help me out in the below query's to go further
in hive.
1.How can i load an large text into an hive table ,and the
syntax of that.
2.Is it possible in hive to process an unstructured data i.e
audio ,image and smiley symbol purely unstru
You mean this one? Hive 0.8 doesn't have CROSS JOIN, so I don't know
if this query works.
SELECT
A.userType
, A.userType_count/B.global_count
FROM
(
SELECT
userType
, COUNT(1) as userType_count
FROM
some_table
GROUP BY
userType
) A
CRO
Hi,
You could use a cross join.
You basically have one table
select
userType
, count(1)
from
some_table
group by
userType
and a second one
select count(1) from some_table
With a cross join you can add the global count to every results in the
first table and compute a ratio.
I have a table, containing userId and userType.
userIduserType
1A
2B
3C
4A
5B
6B
I want to get percentage of each userType.
My current solution:
1. Get count of each group via THRIFT
select
userType
, count(1)
from
some_table
group by
userType
2. Calc
I've tried to deserialize your data.
0 = bigint = -6341068275337623706
1 = string = TTFVUFHFH
2 = int = -1037822201
3 = int = -1467607277
4 = int = -1473682089
5 = int = -1337884091
6 = string = I
7 = string = IVH ISH
8 = int = -1321908327
9 = int = -1475321453
10 = int = -1476394752
11 = string =
I am not sure, what can be the issue...I had it long back and got no
response. I tried these things:
1. Increased the Child JVM heap size.
2. Reduced the number of reducers for the job.
3. Check whether your disks are not getting full while running the query.
3. Checked my data again. I think many
Hi praveenesh kumar :
I am getting the same error today.
Do you have any solution ?
2012/3/23 praveenesh kumar
> Hi all,
>
> I am getting this following error when I am trying to do select ...with
> group by operation.I am grouping on around 25 columns
>
> java.lang.RuntimeException:
> org.ap
I would like to subscribe to Hive user mail list
Hi Matouk,
Thank you so much for your reply, problem is with the classpath. Now it
works fine.
Regards,
Tamil
On Thu, Sep 6, 2012 at 9:26 PM, Matouk Iftissen wrote:
> Hello,
>
> **· **With UDF you do this :
>
> package com.example.hive.udf;
>
> import org.apache.hadoop.hiv
Hello,
· With UDF you do this :
package com.example.hive.udf;
import org.apache.hadoop.hive.ql.exec.UDF;
public final class Maclass extends UDF{.}
· then you generate your jar monjar.jar (for example) with java class
(maclass)
· you add you jar to hive:
hiv
Hi Experts,
I have written an UDAF function and followed the below steps.
Step 1:
Export jar file
Step 2:
hive>ADD JAR /userdata/tamil/SumOfColumnTest/AvgOfColumn.jar;
(also tried with hive --auxpath
/userdata/tamil/SumOfColumnTest/AvgOfColumn.jar;
export HADOOP_CLASSPATH=
Hi,
configure Hive 0.8.1 upon Hadoop 0.20.2 in Cygwin (on windows 7 64 bit). Hive
is started properly as I am getting Hive CLI when type hive. But while running
any command in hive its not returning any response.
Ajit.Shreevastava@hclt-40124697 ~
$ hive
Logging initialized using configuration in
13 matches
Mail list logo
