Hello Everyone:
I'm using Hive .9. MapR ODBC driver against Cloudera. Relatively new to
Hadoop, been looking at it about a week to add it to our query tool.
CREATE DATABASE test;
CREATE TABLE test.table1
(col1 int);
describe table1;
I'm getting the message "Table table1 does
Hi,
I am having issues in accessing the UDF function from the hive queries using
jdbc. Is it possible to access UDF function from the jdbc? I will explain the
steps below and also the error which I am getting.
I had copied the jar which has the UDF class file in the directory
/user/temp/folder
Thanks for the update, Marc. Could you please create a Hive JIRA for this?
Thanks!
Harsh, it's most likely the case with your JIRA as well that the error
message is misleading. Thanks for reporting it!
Mark
On Thu, Jan 31, 2013 at 4:58 PM, Marc Limotte wrote:
> Thanks, Harsh. My issues seems
Thanks, Harsh. My issues seems to be related to the one-user limitation
of the derby metastore. Once that issue was resolved the "table not found"
error went away. It was just a misleading error message.
Marc
On Thu, Jan 31, 2013 at 4:40 PM, Harsh J wrote:
> Not sure how relevant it is but
If you go to /tmp//hive.log you would get a detailed explanation on what
might be wrong. Can you provide that?
From here atleast, it seems like a classpath issue of hive not being able to
find the hbase handler jar which can be solved by 'add jar
hive-hbase-handler-xxx.jar'.
On Jan 31, 2013, a
Not sure how relevant it is but I faced a similar problem around ALTER
TABLE DROP PARTITION IF EXIST.
See https://issues.apache.org/jira/browse/HIVE-3576 for the specific
issue and my commands to reproduce it, and also try to perhaps set
hive.exec.drop.ignorenonexistent to true to see if it change
Thanks, that seems like a reasonable summary of my options.
Cheers!
On Jan 31, 2013, at 14:38 , Edward Capriolo wrote:
> You can execute dfs commands from inside hive
>
> hive>dfs -ls
>
> You can also use virtual columns inside a select
>
> https://cwiki.apache.org/Hive/languagemanual-virtual
You can execute dfs commands from inside hive
hive>dfs -ls
You can also use virtual columns inside a select
https://cwiki.apache.org/Hive/languagemanual-virtualcolumns.html
However there is no direct command in hive to list the files in a
table/partition.
On Thu, Jan 31, 2013 at 4:55 PM, Keith
+1 and +1 non-binding.
Great to see this happen!
Thanks,
+Vinod
On Thu, Jan 31, 2013 at 12:14 AM, Namit Jain wrote:
> +1 and +1
>
> On 1/30/13 6:53 AM, "Gunther Hagleitner"
> wrote:
>
> >+1 and +1
> >
> >Thanks,
> >Gunther.
> >
> >
> >On Tue, Jan 29, 2013 at 5:18 PM, Edward Capriolo
> >wrote
Hi Mark,
A table. But it doesn't seem to matter. I get this error on the DROP,
before even attempting to create a table. I get the same thing for any
arbitrary table name. For example:
hive> DROP TABLE IF EXISTS kdsjhfkjhds;
FAILED: Error in semantic analysis: Table not found kdsjhfkjhds
I
Hmmm, that doesn't seem to list the files in the directory.
On Jan 31, 2013, at 12:12 , Edward Capriolo wrote:
> Try
> describe extended
> or
> describe extended ()
>
> the location is one of the properties
>
> Edward
>
>
> On Thu, Jan 31, 2013 at 2:37 PM, Keith Wiley wrote:
>> "show table
Try
describe extended
or
describe extended ()
the location is one of the properties
Edward
On Thu, Jan 31, 2013 at 2:37 PM, Keith Wiley wrote:
> "show tables" shows the HDFS directories which correspond to Hive tables and
> various select queries show data from inside the files (each row of
Marc,
It seemed to work on my installation of Hive 0.9. Is this a table or a view
you are trying to drop?
Mind sharing the create table definition?
Mark
On Thu, Jan 31, 2013 at 10:42 AM, Marc Limotte wrote:
> Hi,
>
> I'm testing with Hive 0.9.0 (in Amazon EC2, but NOT emr). I'm
> experiencing
"show tables" shows the HDFS directories which correspond to Hive tables and
various select queries show data from inside the files (each row of a file
being a row of the overarching table that the entire directory represents)...or
so I have convinced myself...but can Hive show the HDFS filename
Hi,
I'm testing with Hive 0.9.0 (in Amazon EC2, but NOT emr). I'm experiencing
a problem where DROP TABLE does not respect the IF EXISTS clause, so it
still throws an error when the table doesn't exist and this causes the
script to stop executing. Here's what it looks like from the hive shell:
+1 and +1
On 1/30/13 6:53 AM, "Gunther Hagleitner"
wrote:
>+1 and +1
>
>Thanks,
>Gunther.
>
>
>On Tue, Jan 29, 2013 at 5:18 PM, Edward Capriolo
>wrote:
>
>> Measure 1: +1
>> Measure 2: +1
>>
>> On Mon, Jan 28, 2013 at 2:47 PM, Carl Steinbach wrote:
>>
>> > I am calling a vote on the following t
16 matches
Mail list logo
