Home | About | Sematext search-lucene.com search-hadoop.com search-devops.com
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
clear query|facets|time Search criteria: .   Results from 1 to 10 from 20 (0.261s).
Loading phrases to help you
refine your search...
Pointing SparkSQL to existing Hive Metadata with data file locations in HDFS - Hive - [mail # user]
...hey guysOn the Hive/Hadoop ecosystem we have using Cloudera distribution CDH 5.2.x , there are about 300+ hive tables.The data is stored an text (moving slowly to Parquet) on HDFS.I want to ...
   Author: Sanjay Subramanian, 2015-05-28, 00:45
[expand - 1 more] - SemanticException TOK_ALLCOLREF is not supported in current context (when defined within a VIEW) - Hive - [mail # user]
...hey guysTHIS WORKS  SELECT         distinct *  FROM        cdr_mjp_uni_srch_usr_hist  ; THIS FAILSCREATE DATABASE IF NOT EXISTS cdr;USE cdr;DROP VIEW IF EXISTS         cdr_mjp_uni_srch_usr_h...
   Author: Sanjay Subramanian, 2015-05-18, 17:52
Using Hive as a file comparison and grep-ping tool - Hive - [mail # user]
...hey guysAs data wranglers and programmers we often need quick tools. One such tool I need almost everyday is one that greps a file based on contents of another file. One can write this in pe...
   Author: Sanjay Subramanian, 2015-04-20, 17:43
Re: [ANN] Hivemall v0.3 is now available - Hive - [mail # user]
...awesome thank u. really value your ML contributions.regardssanjay      From: Makoto Yui  To: [EMAIL PROTECTED]  Sent: Friday, February 6, 2015 3:31 AM Subj...
   Author: Sanjay Subramanian, 2015-02-09, 05:12
[expand - 2 more] - Hive JSON Serde question - Hive - [mail # user]
...hey guys This is the Hive table definition I have created based on the JSON I am using this version of hive json serde https://github.com/rcongiu/Hive-JSON-SerdeADD JAR /home/sanjay/mycode/j...
   Author: Sanjay Subramanian, 2015-01-25, 16:05
[expand - 1 more] - Writing Hive Query Output to local system - Hive - [mail # user]
...hey guysI recall this did not happen in the days of 0.9.x versionBut I use 0.13.x now and when I run a hive query hive -e "select * from tablename" > ./myfile.txtThe first line in myfile....
   Author: Sanjay Subramanian, 2015-01-16, 19:05
Using IF in the JOIN  clause - Hive - [mail # user]
...hey guysThis is a portion of a long query we wrote.Can u advise if the bold portion will work ?    and if(f.fr_name is not null, f.fr_name, e.fr_name)=d.fr_name     and if(f.pos_bin is not n...
   Author: Sanjay Subramanian, 2015-01-09, 00:08
Re: How to convert RDBMS DDL to Hive DDL ? - Hive - [mail # user]
...@Krishare u looking for an automated tool that takes RDBMS DDL as input and outputs Hive DDL ?I exported the DDLS of all tables with col sequence numbersI wrote code that converted all DB2 t...
   Author: Sanjay Subramanian, 2015-01-09, 00:04
Re: It's extremely slow when hive reads compression files - Hive - [mail # user]
...It could be the serde that is slow and not the compression ?If your input XML is in multiline records then u may wanna write a bit of RecordReader code to process the multiline XML yourself,...
   Author: Sanjay Subramanian, 2014-10-22, 15:47
Re: Migration of metastore tables from mysql to oracle. - Hive - [mail # user]
...First question, Why are u migrating to Oracle ? Since u never store data on Hive Metastore MYSQL is a great choice. I have done a MYSQL to MYSQL transfer From the source DB mysql dump, it sh...
   Author: Sanjay Subramanian, 2014-10-21, 21:24
Sort:
project
Spark (20)
Hive (19)
Impala (14)
Hadoop (1)
type
mail # user (19)
issue (1)
date
last 7 days (0)
last 30 days (0)
last 90 days (2)
last 6 months (4)
last 9 months (20)
author
Namit Jain (609)
Brock Noland (458)
Carl Steinbach (332)
Sergey Shelukhin (329)
Ashutosh Chauhan (325)
Navis (318)
Zheng Shao (283)
Gunther Hagleitner (273)
Thejas M Nair (264)
Xuefu Zhang (251)
Eugene Koifman (189)
Gopal V (185)
Alan Gates (165)
Ning Zhang (153)
Jason Dere (149)
Alexander Pivovarov (147)
Kevin Wilfong (147)
John Sichi (146)
He Yongqiang (135)
Vaibhav Gumashta (130)
Szehon Ho (127)
Vikram Dixit K (121)
Sushanth Sowmyan (118)
Harish Butani (110)
Prasanth J (108)
Hari Sankar Sivarama Subr...(97)
Edward Capriolo (92)
Jitendra Nath Pandey (89)
Laljo John Pullokkaran (89)
Chengxiang Li (88)
Sanjay Subramanian
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB