On Mon, Dec 20, 2010 at 1:16 AM, iryoung jeong iryo...@gmail.com wrote:
Hello, there.
I found that running hive with sql file caused error messages because of
comments.
For example, me and data analysts in my company think these sql file is make
sense.
On Mon, Dec 20, 2010 at 10:30 AM, Edward Capriolo edlinuxg...@gmail.com wrote:
On Mon, Dec 20, 2010 at 1:16 AM, iryoung jeong iryo...@gmail.com wrote:
Hello, there.
I found that running hive with sql file caused error messages because of
comments.
For example, me and data analysts in my
Often I forget to name a column that results from running an
aggregation. Then, I'm stuck: describe table lists those columns by
their default names, i.e. something like _c1, but I can't seem to
query or rename those columns:
alter table fb_images1 change _c5 ref_array arraystring;
FAILED: Parse
Enclose them in backticks.
alter table fb_images1 change `_c5` ref_array arraystring;
JVS
On Dec 20, 2010, at 3:23 PM, Leo Alekseyev wrote:
Often I forget to name a column that results from running an
aggregation. Then, I'm stuck: describe table lists those columns by
their default names,
Have you found anything interesting from Hive history file
(/tmp/hadoop/hive_job_log_hadoop_201012210353_775358406.txt) ?
Thanks
On Mon, Dec 20, 2010 at 6:11 PM, Sean Curtis sean.cur...@gmail.com wrote:
just running a simple select count(1) from a table (using movielens as an
example) doesnt
Sean Curtis wrote:
just running a simple select count(1) from a table (using movielens as an
example) doesnt seem to work for me. anyone know why this doesnt work? im
using hive trunk:
hive select avg(rating) from movierating where movieid=43;
Total MapReduce jobs = 1
Launching Job 1 out of
in failed/killed task attempts, i see the following:
attempt_201012141048_0023_m_00_0task_201012141048_0023_m_00172.24.10.91FAILED
Too many fetch-failures
Last 4KB
Last 8KB
All
attempt_201012141048_0023_m_00_1task_201012141048_0023_m_00172.24.10.91FAILED
Too many fetch-failures
Sean Curtis wrote:
in failed/killed task attempts, i see the following:
attempt_201012141048_0023_m_00_0task_201012141048_0023_m_00
http://localhost:50030/taskdetails.jsp?tipid=task_201012141048_0023_m_00172.24.10.91
http://172.24.10.91:50060FAILED
Too many fetch-failures
Last
oh, that might be a right issue. It's already there long time ago.
I'll submit patch to there.
thanks :)
On Tue, Dec 21, 2010 at 1:27 AM, Edward Capriolo edlinuxg...@gmail.comwrote:
On Mon, Dec 20, 2010 at 10:30 AM, Edward Capriolo edlinuxg...@gmail.com
wrote:
On Mon, Dec 20, 2010 at 1:16