Hi all,
I have created an external hive table with the STORED AS SEQUENCEFILE
option.However,when I try to load a blank file into that table it gives me the
following error:
Failed with exception Wrong file format. Please check the file's format.
FAILED: Execution Error, return code 1 from
I don't think so:
Object deserialize(Writable blob) throws SerDeException;
On Mon, Mar 21, 2011 at 4:55 AM, 幻 ygnhz...@gmail.com wrote:
Hi,all.Is it possible to generate mutiple records in one SerDe? I mean if I
can return more than one rows in deserialize?
Thanks!
Hi,
Does hive support dynamic configuration? For example: is it possible to write a
hive script with some ${PARAM} variables and let hive replace these parameters
with their values at runtime.
Eg.
Original hive script:
select * from person where age ${MIN_AGE};
Config file:
MIN_AGE=18
And
We use the Cloudera Oozie distro which has a Hive action, and provides that
kind of template support for Hive scripts.
On Mar 21, 2011, at 11:35 AM, Lenin Gali wrote:
Best way to do this is to write shell or python scripts and echo with
substitute variables and call hive from command line
That message is saying, 'found all drivers, trying to connect to specified
metastore db. Can't'.
Check the following:
- MySQL/Derby server running
- correct ip/hostname specified (I've had troubles with dynamic ips)
- userid/pwd exists on server and has correct grants
- will need
On Mon, Mar 21, 2011 at 11:43 AM, Andrew Wilson awil...@conductor.com wrote:
We use the Cloudera Oozie distro which has a Hive action, and provides that
kind of template support for Hive scripts.
On Mar 21, 2011, at 11:35 AM, Lenin Gali wrote:
Best way to do this is to write shell or
Any plans, if possible, to allow you to set the variable from a query result
e.g. 'set zzz = (select count(1) from t)'?
On Mon, Mar 21, 2011 at 5:20 PM, Edward Capriolo edlinuxg...@gmail.comwrote:
On Mon, Mar 21, 2011 at 11:43 AM, Andrew Wilson awil...@conductor.com
wrote:
We use the
Hi!
I've tried to run a create table statement via the HiveCLI in Eclipse
and it fails with the following exception:
FAILED: Error in metadata: MetaException(message:Got exception:
java.io.FileNotFoundException File file:/user/hive/warehouse/customer
does not exist.)
11/03/21 19:05:36 ERROR
You can probably do this in Bash now, try something like this:
zz=`hive -S -e select count(1) from t`
~Avram
~ Avram Aelony|Sr. Analyst|eHarmony.com|(424) 258-1199|x1098|skype:
avram.aelony ~
On Mar 21, 2011, at 3:55 PM, Sameer Kalburgi wrote:
Any plans, if possible, to allow you to set