Check this for your first question:
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Recoverpartitions
Please post if you find any solution for your 2nd and 3rd questions.
Regards,
Ramki.
On Thu, Mar 7, 2013 at 8:01 PM, Suresh Krishnappa
I am not sure whether it works but try this:
Put your ADD JAR commands into a file and invoke hive with -i file option.
or
insert your ADD JAR commands in your $HOME/.hiverc file and start hive.
-Ramki.
On Fri, Mar 8, 2013 at 11:55 PM, Edward Capriolo edlinuxg...@gmail.comwrote:
BTW if your looking for protobuf + hive you should look at...
https://github.com/edwardcapriolo/hive-protobuf/
On Sat, Mar 9, 2013 at 12:32 PM, Ramki Palle ramki.pa...@gmail.com wrote:
I am not sure whether it works but try this:
Put your ADD JAR commands into a file and invoke hive with -i
Suresh,
By default, the partition column name has to be appear in HDFS
directory structure.
e.g.
/user/hive/warehouse/table name/partition col name=partition col
value/data1.txt
/user/hive/warehouse/table name/partition col name=partition col
value/data2.txt
On Thu, Mar 7, 2013 at 7:20 AM,
As you can run the hadoop dfs commands from inside Hive, you can put both
the commands in a script file and run the script file using hive. These are
still two different commands but are together at one place and can be
executed in the same environment in one go.
-Ramki.
On Fri, Mar 8, 2013 at
Created https://issues.apache.org/jira/browse/HIVE-4144
On Fri, Mar 8, 2013 at 5:25 AM, Dean Wampler
dean.wamp...@thinkbiganalytics.com wrote:
It's odd that there is no such command. The trick Ramki mentioned is the
only one I know of. Two points about it, though:
1. It only works on Hive
while trying to create external table in oozie hive action, I am
getting following error, hive version is 0.9.0
Caused by: javax.jdo.JDODataStoreException: Insert of object
org.apache.hadoop.hive.metastore.model.MColumnDescriptor@46c1dc0b
using statement INSERT INTO `CDS` (`CD_ID`) VALUES (?)
Is this is a new installation of Hive or did you upgrade ? How many tables
do you already have ?
On Sat, Mar 9, 2013 at 12:00 PM, Abhishek Gayakwad a.gayak...@gmail.comwrote:
while trying to create external table in oozie hive action, I am getting
following error, hive version is 0.9.0
Another alternative way, just say
Desc extended table_name
There we can see the db name of the table
—
Sent from iPhone
On Sun, Mar 10, 2013 at 1:02 AM, Mark Grover grover.markgro...@gmail.com
wrote:
Created https://issues.apache.org/jira/browse/HIVE-4144
On Fri, Mar 8, 2013 at 5:25 AM,
Just wondering if your create table syntax include if not exists such as
CREATE EXTERNAL TABLE IF NOT EXISTS my_table (
...
...
...
)
On Sun, Mar 10, 2013 at 2:34 AM, Viral Bajaria viral.baja...@gmail.comwrote:
Is this is a new installation of Hive or did you upgrade ? How many tables
do
it is an old installation, we recently upgraded hive 0.7.0 to 0.9.0
and we are not using if not exists clause
On Sun, Mar 10, 2013 at 4:37 AM, Ramki Palle ramki.pa...@gmail.com wrote:
Just wondering if your create table syntax include if not exists such as
CREATE EXTERNAL TABLE IF NOT
11 matches
Mail list logo