Re: May 2018 Hive User Group Meeting

2018-06-11 Thread Mich Talebzadeh
yes indeed I second that Regards Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* http://talebzadehmich.wordpress.com *Disclaimer:*

Re: Jimmy Xiang now a Hive PMC member

2017-05-25 Thread Mich Talebzadeh
Best wishes in the new role Jimmy. Regards, Mich Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* http://talebzadehmich.wordpre

Re: [ANNOUNCE] Apache Hive 2.0.1 Released

2016-05-31 Thread Mich Talebzadeh
. With Hive on Spark vs Hive on MapReduce the performance gains are order of magnitude. HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*

Hive and using Pooled Connections

2016-05-25 Thread Mich Talebzadeh
the reuse of connection objects and reduce the number of times that connection objects are created. Connection pools significantly improve performance for database-intensive applications because creating connection objects is costly both in terms of time and resources. Thanks Dr Mich Talebzadeh

Re: Predicates for 'like' and 'between' operators to custom storage handler.

2016-05-05 Thread Mich Talebzadeh
Hi, Do you have the equivalent of that operation in pure SQL. Also have you tried Spark query tool with Hive table. I gather you are doing this through Java? Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw <ht

Re: Predicates for 'like' and 'between' operators to custom storage handler.

2016-05-05 Thread Mich Talebzadeh
row selected (153.959 seconds) So it does work HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* http://talebzadehmich.wordpress.com

Re: Predicates for 'like' and 'between' operators to custom storage handler.

2016-05-05 Thread Mich Talebzadeh
yyy-MM-dd')) AS TransactionDate Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* http://talebzadehmich.wordpress.com On 5 May 2016 at 13:25

[jira] [Created] (HIVE-13574) Standard Deviation in Hive 2 is still incorrect

2016-04-21 Thread Mich Talebzadeh (JIRA)
Mich Talebzadeh created HIVE-13574: -- Summary: Standard Deviation in Hive 2 is still incorrect Key: HIVE-13574 URL: https://issues.apache.org/jira/browse/HIVE-13574 Project: Hive Issue Type

Re: Hive SQL query

2016-04-07 Thread Mich Talebzadeh
e -u jdbc:hive2://HOST:POPRT/default org.apache.hive.jdbc.HiveDriver -n hduser -p xx HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>

Re: analyse command not working on decimal(38,0) datatype

2016-04-06 Thread Mich Talebzadeh
plus the version of version of Hive Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* http://talebzadehmich.wordpress.com On 6 April 2

RE: Answers to recent questions on Hive on Spark

2015-11-30 Thread Mich Talebzadeh
Hi, As I mentioned that parameter does not seem to work I am afraid! hive> set hive.spark.client.server.address=50.140.197.217; Query returned non-zero code: 1, cause: hive configuration hive.spark.client.server.address does not exists. Mich Talebzadeh Sybase ASE 15 Gold Me

RE: Answers to recent questions on Hive on Spark

2015-11-30 Thread Mich Talebzadeh
em with spark applications such as SparkSQL, but it shouldn't be a concern if you decide that you use Hive in Hive. Let me know if you are still confused. Thanks, Xuefu On Fri, Nov 27, 2015 at 4:34 PM, Mich Talebzadeh mailto:m...@peridale.co.uk> > wrote: Hi, Thanks for

RE: Answers to recent questions on Hive on Spark

2015-11-30 Thread Mich Talebzadeh
ddress that works. It does not work in hive-site.xml Starting Hive Metastore Server 2015-11-28 10:30:15,372 WARN [main] conf.HiveConf: HiveConf of name hive.spark.client.server.address does not exist Mich Talebzadeh Sybase ASE 15 Gold Medal Award 2008 A Winning Strategy: Running

RE: Answers to recent questions on Hive on Spark

2015-11-30 Thread Mich Talebzadeh
s on port 6066 15/11/28 00:31:27 INFO master.Master: I have been elected leader! New state: ALIVE Thanks again. Mich Talebzadeh Sybase ASE 15 Gold Medal Award 2008 A Winning Strategy: Running the most Critical Financial Data on ASE 15 <http://login.sybase.com/files/Product_Ove

RE: [ANNOUNCE] New Hive Committers - Jimmy Xiang, Matt McCline, and Sergio Pena

2015-03-23 Thread Mich Talebzadeh
Me too J Mich Talebzadeh http://talebzadehmich.wordpress.com Publications due shortly: Creating in-memory Data Grid for Trading Systems with Oracle TimesTen and Coherence Cache NOTE: The information in this email is proprietary and confidential. This message is for the