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 wrote:
> Just wondering if your create table syntax include "if not exists" such as
>
> CREATE EXTERNAL TABLE IF NOT EXISTS my_table (
>
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 wrote:
> Is this is a new installation of Hive or did you upgrade ? How many tables
> do you already have ?
>
Another alternative way, just say
Desc extended
There we can see the db name of the table
—
Sent from iPhone
On Sun, Mar 10, 2013 at 1:02 AM, Mark Grover
wrote:
> Created https://issues.apache.org/jira/browse/HIVE-4144
> On Fri, Mar 8, 2013 at 5:25 AM, Dean Wampler
> wrote:
>> It's odd
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 wrote:
> while trying to create external table in oozie hive action, I am getting
> following error, hive version is 0.9.0
>
>
> Caused by: javax.jd
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 (?)"
Created https://issues.apache.org/jira/browse/HIVE-4144
On Fri, Mar 8, 2013 at 5:25 AM, Dean Wampler
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 v0.8+.
> 2. I've seen a few cases
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 5
Suresh,
By default, the partition column name has to be appear in HDFS
directory structure.
e.g.
/user/hive/warehouse//=/data1.txt
/user/hive/warehouse//=/data2.txt
On Thu, Mar 7, 2013 at 7:20 AM, Suresh Krishnappa
wrote:
> Hi All,
> I have the following directory structure in hdfs
>
> /test/a/
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 wrote:
> 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.
>
> o
2) Getting 'out of memory' java exception while adding partitions > 5
3) Sometimes getting 'out of memory' java exception for select queries for
partitions > 1
So hive/hadoop have to "plan" the job. Planning involves building all the
partitions into a list (in memory) of the client. It als
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 wrote:
> Essentially anything that is p
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 <
suresh.krishna...
12 matches
Mail list logo
