Fwd: BUG ? Loss of all table data when deleting partitions performed directly on hdfs (after metastore synchro)

2023-08-17 Thread Jeremy Ferrer
he case where the table had the propertie 'external.table.purge'='TRUE' and in the case where the partition was of type Int (no problem on partitions of type string, only the good partition is removed) I'm using Hive 3.1.0. Do you have any idea of the problem? Best regards, Jeremy

Is it possible to do a LEFT JOIN LATERAL in Hive?

2015-04-04 Thread Jeremy Davis
Hello! I would like to do a LEFT JOIN LATERAL .. Which is using values on the LHS as parameters on the RHS. Is this sort of thing possible in Hive? -JD Some example SQL: create table lhs ( subject_id integer, date_time BIGINT ); —Subjects and responses at Arbitrary res

Re: In need of desperate help and willing to pay for consulting work

2014-04-15 Thread Jeremy
kay with latency > and the absence of all the features that a RDBMS provides and hive doesn't. > > This is > > > > > On Tue, Apr 15, 2014 at 11:33 PM, Prasan Samtani > mailto:prasan.samt...@hulu.com>> wrote: > > Hi Jeremy, > > The sug

Re: In need of desperate help and willing to pay for consulting work

2014-04-15 Thread Jeremy
Thanks for the feed back. I will spend time looking in it. Thanks again On 04/15/2014 12:03 PM, Prasan Samtani wrote: > Hi Jeremy, > > The suggestions given are for precisely the use case you described. A > warning: It's not going to be a matter of simple substituti

Re: In need of desperate help and willing to pay for consulting work

2014-04-15 Thread Jeremy
Just in case there is confusion I have an API that needs to talk to hive. At the moment it is using mysql Thanks for the reply’s On 04/15/2014 11:41 AM, Ravi Mummulla (BIG DATA) wrote: > Use Templeton rest API to hive server 2. > > Thanks. > > -Original Message-

In need of desperate help and willing to pay for consulting work

2014-04-15 Thread Jeremy
What do I need to do to send a php command from a php api to query the hive server? I am just trying to replace mysql with hive. This should be as simple as 1 2 3 But for months I have not been able to find this answer. It has to be out there because many people are still using PHP. Why would

Re: How do I get the php client to run?

2014-03-28 Thread Jeremy
b/php) > > Hope It Helps, > Chinna > > > On Fri, Mar 28, 2014 at 12:14 AM, Jeremy <mailto:jk...@kickbackpoints.com>> wrote: > > Or how do query hive from php? > > On 03/27/2014 12:25 PM, Jeremy wrote: > > Or is there another way I can

Re: How do I get the php client to run?

2014-03-27 Thread Jeremy
Or how do query hive from php? On 03/27/2014 12:25 PM, Jeremy wrote: > Or is there another way I can pull data from hive using php? > > On 03/27/2014 11:54 AM, Jeremy wrote: >> https://cwiki.apache.org/confluence/display/Hive/HiveClient#HiveClient-PHP >> >> What kind

Re: How do I get the php client to run?

2014-03-27 Thread Jeremy
Or is there another way I can pull data from hive using php? On 03/27/2014 11:54 AM, Jeremy wrote: > https://cwiki.apache.org/confluence/display/Hive/HiveClient#HiveClient-PHP > > What kind of setup and what do I need to do to get this client to run? > > > // set THRIFT_ROO

How do I get the php client to run?

2014-03-27 Thread Jeremy
https://cwiki.apache.org/confluence/display/Hive/HiveClient#HiveClient-PHP What kind of setup and what do I need to do to get this client to run? open(); // run queries, metadata calls etc $client->execute('SELECT * from src'); var_dump($client->fetchAll()); $transport->close(); Thanks

Re: the php client seems to be broken

2014-03-17 Thread Jeremy
e/metastore/Types.php on line 4891" even though the file is included. Any one know how to resolve these issues? On 03/17/2014 11:45 AM, Jeremy wrote: > I am trying to use the php hive thift client and there is name space and > autoload issues. > Autoload is not generated and I have

the php client seems to be broken

2014-03-17 Thread Jeremy
I am trying to use the php hive thift client and there is name space and autoload issues. Autoload is not generated and I have not found any instructions how to properly generate it. Also some files contain namespace; which is a syntax issue. Is any one aware of these issues and know how to fix the