Re: Need help with query

Hi there, The detailed error should be in the hiveserver2.log Cheers, Andrew On Wed, Sep 21, 2016 at 3:36 PM, Igor Kravzov < igork.ine...@gmail.com [igork.ine...@gmail.com] > wrote: I run MSCK REPAIR TABLE mytable; and got Error while processing statement: FAILED: Execution Error, return code

Re: Need help with query

I run MSCK REPAIR TABLE mytable; and got Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask On Mon, Sep 12, 2016 at 6:56 PM, Lefty Leverenz wrote: > Here's a list of the wikidocs about dynamic partitions >

Re: Need help with query

Here's a list of the wikidocs about dynamic partitions . -- Lefty On Mon, Sep 12, 2016 at 3:25 PM, Devopam Mittra wrote: > Kindly learn dynamic partition from cwiki. That will be the perfe

Re: Need help with query

Kindly learn dynamic partition from cwiki. That will be the perfect solution to your requirement in my opinion. Regards Dev On 13 Sep 2016 12:49 am, "Igor Kravzov" wrote: > Hi, > > I have a query like this one > > alter table my_table > add if not exists partition (mmdd=20160912) location

Need help with query

Hi, I have a query like this one alter table my_table add if not exists partition (mmdd=20160912) location '/mylocation/20160912'; Is it possible to make so I don't have to change date every day? Something with CURRENT_DATE;? Thanks in advance.

RE: Help with query

IT Security Operations • | | • [Microsoft Logo] From: Petter von Dolwitz (Hem) [mailto:petter.von.dolw...@gmail.com] Sent: Thursday, 5 June, 2014 01:33 To: user@hive.apache.org Subject: Re: Help with query I tried to answer this earlier. Maybe the mail got suck somewhere. I'll try

Re: Help with query

I tried to answer this earlier. Maybe the mail got suck somewhere. I'll try again. SELECT COUNT(DISTINCT ip) AS count, query_string FROM myTable GROUP BY query_string ORDER BY count DESC; This should give you one row per asked query. Rows are ordered by number of unique IPs that asked the query.

Re: Help with query

can you put your example with sample data and expected result output? On Fri, May 30, 2014 at 4:59 AM, Software Dev wrote: > We have a table with user entered queries, their IP. How could we > write a query that will count and order queries by their count having > a unique IP count > X. For exa

Re: Help with Query

SELECT COUNT(DISTINCT ip) AS count, query_string FROM myTable GROUP BY query_string ORDER BY count DESC; This should give you one row per asked query. Rows are ordered by nummer of unique IPs that asked the query. Most popular first. Br, Petter Den 30 maj 2014 19:17 skrev "Software Dev" : > We h

Help with Query

We have a table with user entered queries, their IP. How could we write a query that will count and order queries by their count having a unique IP count > X. For example if we had the same IP enter the same query Y times we wouldnlt want to include this in the final result unless there have been X

Help with query

We have a table with user entered queries, their IP. How could we write a query that will count and order queries by their count having a unique IP count > X. For example if we had the same IP enter the same query Y times we wouldnlt want to include this in the final result unless there have been X

Help with query

We have a table with user entered queries, their IP. How could we write a query that will count and order queries by their count having a unique IP count > X. For example if we had the same IP enter the same query Y times we wouldnlt want to include this in the final result unless there have been X