| clear query|facets|time |
Search criteria: .
Results from 51 to 58 from
58 (0.175s).
|
|
|
Loading phrases to help you
refine your search...
|
|
Re: Searching for a string off a group by query - Hive - [mail # user]
|
|
...Then I think the array_contains is your best bet. See my example query below. I used a subquery (always handy) also I replaced count(activityID) in your SQL with count(1) T...
|
|
|
Author: John Omernik,
2012-07-17, 13:01
|
|
|
Re: Searching for a string off a group by query - Hive - [mail # user]
|
|
...Not sure what you are trying to do, but you may want to check out the array_contains function. Also, if you are using Hive 9 you can use the concat_ws() function. This is taken from a ...
|
|
|
Author: John Omernik,
2012-07-17, 03:20
|
|
|
Re: Anything wrong with this query? - Hive - [mail # user]
|
|
...The LEFT and the RIGHT JOIN is invalid, you need LEFT OUTER JOIN or RIGHT OUTER JOIN or just JOIN (no INNER JOIN) On Fri, Jul 13, 2012 at 11:06 AM, Raihan Jamal wrote: &nb...
|
|
|
Author: John Omernik,
2012-07-14, 18:52
|
|
|
[HIVE-2633] Implement a Join_Array Functions within Hive. Join Elements of the Array with a delimiter and return a string. - Hive - [issue]
|
|
...When working with arrays, there are times where it would be very beneficial to take the results of an array generating functions such as collect_set and convert that to a delimited string fo...
|
|
|
http://issues.apache.org/jira/browse/HIVE-2633
Author: John Omernik,
2012-05-28, 18:10
|
|
|
Re: LIKE Statement - Hive - [mail # user]
|
|
...Well the link provided isn't really about what I originally asked about. I have not come across a SQL implementation (Postgres, MySQL, or MSSQL are the ones I have experience in) where...
|
|
|
Author: John Omernik,
2012-05-14, 23:20
|
|
|
LIKE Statement - Hive - [mail # user]
|
|
...I did a test today: select * from table where 'hello' like '%el%' limit 10; I got 10 rows from my table select * from table where 'HELLO' like '%el%' limit 10; I got...
|
|
|
Author: John Omernik,
2012-04-04, 13:40
|
|
|
Re: Hive ODBC - Microsofts Involvement - Hive - [mail # user]
|
|
...I see that, but will that hive ODBC driver work with a standard hive install, or will it be limited to Microsoft's cloud version of Hadoop/Hive? Anyone tried the driver? On Wed, ...
|
|
|
Author: John Omernik,
2012-02-02, 02:40
|
|
|
Hive ODBC - Microsofts Involvement - Hive - [mail # user]
|
|
...Does anyone know if the driver Microsoft is talking about with their Azure based hadoop/hive setup would work for connecting Windows applications (Excel/.NET Web Apps etc) to Apache Hive run...
|
|
|
Author: John Omernik,
2012-02-01, 20:21
|
|
|
|
