Way to go, Kevin! Conratz!
- Alex
On Mar 4, 2013, at 8:54 PM, Carl Steinbach wrote:
> On behalf of the Apache Hive PMC I am pleased to welcome
> Kevin Wilfong as a member of the Apache Hive PMC.
>
> Please join me in congratulating Kevin on his new role!
>
> Thanks.
>
> Carl
--
Alexander Al
No.
Here are the errors:
Task with the most failures(4):
-
Task ID:
task_1361599885844_0013_m_00
URL:
http://localhost.localdomain:50030/taskdetails.jsp?jobid=job_1361599885844_0013&tipid=task_1361599885844_0013_m_00
-
Diagnostic Messages for this Task:
Error: java.lang.RuntimeE
Hi Dilip,
Are you able to run this query successfully?
select d_date_sk, d_date_id, d_date, d_month_seq, d_week_seq,
d_quarter_seq, d_dow, d_moy, d_dom, d_qoy, d_fy_year,
d_fy_quarter_seq, d_fy_week_seq, d_day_name, d_quarter_name,
d_holiday, d_weekend, d_following_holiday, d_first_dom, d_last_dom
None that I know of, but I haven't tried too many cases. Of course, there
shouldn't be ;)
On Mon, Mar 4, 2013 at 6:38 PM, kumar mr wrote:
>
>
> Hi dean,
>
> Are there any known issues if we do LEFT OUTER JOIN between different
> table formats like Text and RCfile? Here the tables are of differ
Hi dean,
Are there any known issues if we do LEFT OUTER JOIN between different table
formats like Text and RCfile? Here the tables are of different format types.
Regards,
Kumar
-Original Message-
From: Dean Wampler
To: user
Sent: Fri, Mar 1, 2013 12:23 pm
Subject: Re: doubt
Regards,
Kumar
-Original Message-
From: Dean Wampler
To: user
Sent: Fri, Mar 1, 2013 12:23 pm
Subject: Re: doubt with LEFT OUTER JOIN
I just tried an experiment where the right-hand table was empty. It worked
fine. Could you post more details, like the query, create table state
Hi Stephan ,
Please use the following desc extended to see where is the table' s directory
on hdfs. Here is an example.
hive -e "desc extended hcatsmokeid0b0abc02_date252113 ;"
WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. Please use
org.apache.hadoop.log.metrics.EventCo
RCFile won't help much (and apparently not all in this case ;) unless you
have a lot of columns and you always query just a few of them. However, you
should get better results with Sequence Files (binary format) and usually
with a compression scheme like BZip that supports block-level (as opposed
t
Hi there,
I've setup a virtual machine hosting Hive.
My use case is a Web traffic analytics, hence most of requests are :
- how many requests today ?
- how many request today, grouped by country ?
- most requested urls ?
- average http server response time (5 minutes slots) ?
In other words, let
The April Bay Area Hive User Group Meetup is happening on
Thursday, April 25th at Hortonworks in Palo Alto. The format will
be a series of short (15 min) talks preceded by refreshments and
networking. Please join me in thanking the folks at Hortonworks
for providing the meeting space and refreshmen
Awesome job, congratulations Kevin!
Jarcec
On Mon, Mar 04, 2013 at 11:54:36AM -0800, Carl Steinbach wrote:
> On behalf of the Apache Hive PMC I am pleased to welcome
> Kevin Wilfong as a member of the Apache Hive PMC.
>
> Please join me in congratulating Kevin on his new role!
>
> Thanks.
>
>
Congrats, Kevin. Keep up the good work!
On Mon, Mar 4, 2013 at 11:54 AM, Carl Steinbach wrote:
> On behalf of the Apache Hive PMC I am pleased to welcome
> Kevin Wilfong as a member of the Apache Hive PMC.
>
> Please join me in congratulating Kevin on his new role!
>
> Thanks.
>
> Carl
Congrats Kevin!
On Mon, Mar 4, 2013 at 12:43 PM, Kevin Wilfong wrote:
> Thanks eveyone!
>
> From: Ricky Saltzer [ri...@cloudera.com]
> Sent: Monday, March 04, 2013 12:13 PM
> To: d...@hive.apache.org
> Cc: user@hive.apache.org; Kevin Wilfong
> Subject: Re: [ANNO
Thanks eveyone!
From: Ricky Saltzer [ri...@cloudera.com]
Sent: Monday, March 04, 2013 12:13 PM
To: d...@hive.apache.org
Cc: user@hive.apache.org; Kevin Wilfong
Subject: Re: [ANNOUNCE] Kevin Wilfong elected to Hive PMC
Congratulations, Kevin!
On Mon, Mar 4, 2013 a
Congratulations, Kevin!
On Mon, Mar 4, 2013 at 2:57 PM, Ashish Thusoo wrote:
> congratulations Kevin!!
>
> Ashish
>
>
> On Mon, Mar 4, 2013 at 11:54 AM, Carl Steinbach wrote:
>
> > On behalf of the Apache Hive PMC I am pleased to welcome
> > Kevin Wilfong as a member of the Apache Hive PMC.
>
On behalf of the Apache Hive PMC I am pleased to welcome
Kevin Wilfong as a member of the Apache Hive PMC.
Please join me in congratulating Kevin on his new role!
Thanks.
Carl
Hi everyone,
I apologize for cross-posting this
Cloudera will be hosting an Oozie meetup on March 12 from 2:30pm to
5:00pm in our Palo Alto office.
Please join us to meet fellow Oozie users and developers and have some
free food. Interested users from other projects are welcome to join us
too.
Sorry for the delayed response, Marcin, I was away.
This error in the Gist means that the jar containing the class in
question is not on your classpath.
Exception in thread "Thread-39" java.lang.NoClassDefFoundError:
org/apache/hadoop/mapreduce/util/HostUtil
at
org.apache.hadoop.hive.shim
Are you using hive over yarn? If yes, see this related thread here[1].
[1]
https://groups.google.com/a/cloudera.org/forum/?fromgroups=#!topic/cdh-user/gHVq9C5H6RE
On Mon, Mar 4, 2013 at 4:49 AM, Bhaskar, Snehalata <
snehalata_bhas...@syntelinc.com> wrote:
> Does anyone know how to solve this i
Does anyone know how to solve this issue??
Thanks and regards,
Snehalata Deorukhkar
Nortel No : 0229 -5814
From: Bhaskar, Snehalata [mailto:snehalata_bhas...@syntelinc.com]
Sent: Sunday, March 03, 2013 11:23 PM
To: user@hive.apache.org
Subject: java.io.FileNotFoundException(File does not exist) w
Thanks Krishna/Nitin.
From: Nitin Pawar
To: user@hive.apache.org
Sent: Monday, 4 March 2013 2:28 AM
Subject: Re: hive commands from a file
Try hive -f filename
On Mar 4, 2013 3:55 PM, "Sai Sai" wrote:
Just wondering if it is possible to run a bunch of
Try hive -f filename
On Mar 4, 2013 3:55 PM, "Sai Sai" wrote:
> Just wondering if it is possible to run a bunch of hive commands from a
> file rather than one a time.
> For ex:
> 1. Create external...
> 2. Load ...
> 3. Select * from ...
> 4
>
> Thanks
> Sai
>
Hi Sai,
just use the "-f" arg together with the file name. For details see:
https://cwiki.apache.org/Hive/languagemanual-cli.html
Krishna
On 4 March 2013 10:24, Sai Sai wrote:
> Just wondering if it is possible to run a bunch of hive commands from a
> file rather than one a time.
> For ex:
>
Just wondering if it is possible to run a bunch of hive commands from a file
rather than one a time.
For ex:
1. Create external...
2. Load ...
3. Select * from ...
4
Thanks
Sai
Thanks Jagat.
From: Jagat Singh
To: user@hive.apache.org; Sai Sai
Sent: Monday, 4 March 2013 1:23 AM
Subject: Re: hive light weight reporting tool
Yes just wait for sometime.
We have awesome people here , they would suggest wonderful solutions to you.
Yes just wait for sometime.
We have awesome people here , they would suggest wonderful solutions to you.
On Mon, Mar 4, 2013 at 8:18 PM, Sai Sai wrote:
> Thanks again Jagat. just wanted to get a second opinion about my excel
> question.
> Thanks again for the input.
> Sai.
>
>
> -
Thanks again Jagat. just wanted to get a second opinion about my excel question.
Thanks again for the input.
Sai.
From: Jagat Singh
To: user@hive.apache.org; Sai Sai
Sent: Monday, 4 March 2013 1:01 AM
Subject: Re: hive light weight reporting tool
Hi,
Th
Hi,
There are many reporting tool which can read from Hive server.
All you need is to start hive server and then point tool to use it.
Pentaho , Talend , ireport are few.
Just search over here.
Thanks.
Jagat Singh
On Mon, Mar 4, 2013 at 7:58 PM, Sai Sai wrote:
> Just wondering if there is
Sai sorry this may look arrogant but did you try google for beginners
On Mar 4, 2013 2:28 PM, "Sai Sai" wrote:
> Just wondering if there is any light weight reporting tool with hive/hadoop
> which we can use for quick POCs.
> Thanks
> Sai
>
Hi,
$hive -e 'select * from myTable' > MyResultsFile.txt
Then you can use this file to import into excel
If you want to use HUE , then it has functionality to export to excel
directly.
Thanks,
Jagat Singh
On Mon, Mar 4, 2013 at 7:56 PM, Sai Sai wrote:
> Just wondering how to save the data
Just wondering if there is any light weight reporting tool with hive/hadoop
which we can use for quick POCs.
Thanks
Sai
Just wondering how to save the data of a query to excel file.
For ex:
After running the query:
Select * from myTable;
we would like to save the query results to xls file.
Any help is appreciated.
Thanks
Sai
Many Thanks Jagat.
Sai
From: Jagat Singh
To: user@hive.apache.org; Sai Sai
Sent: Monday, 4 March 2013 12:44 AM
Subject: Re: hive columns display
Hi,
See this
http://svn.apache.org/repos/asf/hive/trunk/conf/hive-default.xml.template
There is one propert
Hi,
See this
http://svn.apache.org/repos/asf/hive/trunk/conf/hive-default.xml.template
There is one property , if you set that to true it would show.
hive.cli.print.header
false
Whether to print the names of the columns in query
output.
Thanks,
Jagat Singh
On Mon, Mar 4, 2013 at 7:
Select * from table without any where condition will never run MR job
Hive does not cache your query results. If you rerun your query everything
will be repeated for each repeatation
How many days you should keep data...as long as it means something to you
or it has some value in storing foe futu
When we run a query in hive like:
Select * from myTable limit 10;
We get the results successfully but the column names r not displayed.
Is it possible to display the column names also so the data and the columns can
be related right away without running a describe table.
Thanks,
Sai
Hi
I was wondering if it is right to assume:
1. The first time we create a table in hive and load it followed by running the
first query like
Select * from Table1
will result in a MR job running and will get the data to us.
If we run the same query second time MR job will not run but will res
37 matches
Mail list logo
