Hey guys,
I tried to add an external partition for my web_log table, but failed like
below,
hive> ALTER TABLE web_log ADD PARTITION (logdate='20090519') LOCATION
'/user/zhoumin/web_log/20090519/';
FAILED: Error in metadata: MetaException(message:Got exception:
org.apache.hadoop.security.AccessCon
Sorry, my bad! the directory I loaded isn't exists yet.
On Wed, May 20, 2009 at 4:10 PM, Min Zhou wrote:
> Hey guys,
>
> I tried to add an external partition for my web_log table, but failed like
> below,
>
> hive> ALTER TABLE web_log ADD PARTITION (logdate='20090519') LOCATION
> '/user/zhoumin/
Thank you Edward,
It went well at last by copying the *.jar files to hive/lib.
But it's really strange. I have all the directories in my path environment.
In addition, I've tried many times to set it using my .tcshrc files,
hadoop-env.sh etc.
Excuse me for a naive question, but which is the best
I have a RedHat/CentOS system. I find the best way is to add scripts
to /etc/profile.d
/etc/profile.d/hive.sh
---
PATH=$PATH:/opt/hive/bin
ANT_LIB=/opt/ant/lib
export PATH
export ANT_LIB
---
I did something like that here.
http://wiki.apache.org/hadoop/HiveDerbyServerMode
On Wed, May 20, 2009 a
Is it possible for hive to recognize commented rows in a file when it loads
a csv file?
For example, say contents of test.csv is,
#123
#Red, Brown, Black, Blue
3, AB, 5, 3
2, AA, 1, 4
...
In hive, how to ignore first two lines while loading?
Thanks,
Manhee
The Hive internal Serdes do not allow this format yet. We will need to
change Hive code to make that happen.
Specifically, it's the LazySimpleSerDe class.
Zheng
On Wed, May 20, 2009 at 11:05 PM, Manhee Jo wrote:
> Is it possible for hive to recognize commented rows in a file when it loads
> a c
I guess the question was about loading the data. In the load command, we
currently just copy over the data without parsing it (via the CopyTask).
Even though we could choose to neglect commented rows at query time (via
SerDes), its probably more efficient to do it once while loading.
In addition,
