Hi Hive developers,
I am new to hive. Yesterday i installed apache hive-0.9.0 and start executing
some basics command and i found one abnormal behavior in select* command. In
select statement after * any random characters are allowed in hive but in RDBMS
its not allowed. I am not sure its
I couldn't run a HCatalog MapReduce Jar in HDInsight
Syntax is
%hadoop_home%/bin > Hadoop jar -files
%HCAT_JAR% -libjars %lib_jars% tableone tabletwo
ERROR :
Caused by: java.net.URISyntaxException: Illegal character in opaque part at
inde
x 2:
C:\apps\dist\hive-0.13.0.2.1.3.2-0002
Currently there isn’t any support for this in Tez. Expect it to be added
soon.
*From:* Grandl Robert [mailto:rgra...@yahoo.com]
*Sent:* Sunday, September 14, 2014 5:26 PM
*To:* u...@tez.apache.org; user@hive.apache.org
*Subject:* speculative execution in Hive over Tez
Hi guys,
I am wonderi
Hi,
what you are trying to do looks very much like what the LAG windowing
function does.
If your version of Hive is 0.11 or higher, I suggest trying it.
The hive doc for windowing function is here (but is quite poor):
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+WindowingAndAnal
Other way I can think at this is ..
1) ignore all -1 and create a tmp table
2) I see there are couple of time stamps
3) Oder the table by timestamp
4) from this tmp tabel create anothe tmp table which says FK MinStartTime
MaxEndTime Location
5) Now this tmp table from step 4 join with ur raw data
thanks!
is there any other way than writing python UDF etc.
any way i can leverage hive joins to get this working?
On Mon, Sep 15, 2014 at 6:56 AM, Sreenath wrote:
> How about writing a python UDF that takes input line by line
> and it saves the previous lines location and can replace it with
How about writing a python UDF that takes input line by line
and it saves the previous lines location and can replace it with that
if location turns out to be '-1'
On 15 September 2014 17:01, Nitin Pawar wrote:
> have you taken a look at lag and lead functions ?
>
> On Mon, Sep 15, 2014 at 4:46
have you taken a look at lag and lead functions ?
On Mon, Sep 15, 2014 at 4:46 PM, Viral Parikh
wrote:
> To Whomsoever It May Concern,
>
> I posted this question last week but still haven't heard from anyone; I'd
> appreciate any reply.
>
> I've got a table that contains a LocationId field. In s
To Whomsoever It May Concern,
I posted this question last week but still haven't heard from anyone; I'd
appreciate any reply.
I've got a table that contains a LocationId field. In some cases, where a
record shares the same foreign key, the LocationId might come through as -1.
What I want to do i
