Home | About | Sematext search-lucene.com search-hadoop.com
clear query|facets|time Search criteria: .   Results from 1 to 10 from 124 (0.188s).
Loading phrases to help you
refine your search...
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
Re: select * from table and select column from table in hive - Hive - [mail # user]
...One way to debug is to put bash in actionsay you have a data file in hdfs (/data/rockers/rockers.csv) that looks like cust_num,cust_name,instrument1,paul,bass2,john,rhythm3,ringo,drums4,geor...
   Author: Sanjay Subramanian, 2014-10-21, 21:19
Re: Optimize hive external tables with serde - Hive - [mail # user]
...1. The gzip files are not splittable, so gzip itself will make the queries slower.2. As a reference for JSON serdes , here is a example from my blog http://bigdatalatte.wordpress.com/2014/08...
   Author: Sanjay Subramanian, 2014-10-21, 21:12
Re: Weird Error on Inserting in Table [ORC, MESOS, HIVE] - Hive - [mail # user]
...hi I faced a similar situation in my dev cluster CDH distribution 5.1.3See the thread details with log files  https://groups.google.com/a/cloudera.org/forum/#!mydiscussions/scm-users/MpcpHj5...
   Author: Sanjay Subramanian, 2014-10-07, 19:05
Re: Storing result of a query in a variable - Hive - [mail # user]
...Add  -e option./hive -e --hiveconf MY_VAR =`cat /tmp/result/000000_0`;But u could use the following hdfs command as wellMY_VAR=$(hdfs dfs -cat /tmp/result/000000_0)thankssanjay______________...
   Author: Sanjay Subramanian, 2014-06-02, 21:03
Hadoop summit San Jose 5/3/14 - 5/5/14 - Hive - [mail # user]
...hi guys I am going to attend the 3 day hadoop summit in San Jose tomorrow. Looking fwd to the Hive sessions.Hope to see many of u there.regardssanjay ...
   Author: Sanjay Subramanian, 2014-06-02, 20:57
Re: problem with delimiters (control A) - Hive - [mail # user]
...Hi Jack Since u already have your data with columns separated by CtrlA then u need to define the HIVE table as follows (by default Hive will assume CtrlA as column delimiter)create table if ...
   Author: Sanjay Subramanian, 2014-05-29, 23:38
Re: Finding Max of a column without using any Aggregation functions - Hive - [mail # user]
...Thanks For the sake of this question I wanted to avoid all order by and limit syntax 😄. It's more of a challenge question RegardsSanjay Sent from my iPhone ...
   Author: Sanjay Subramanian, 2014-04-23, 14:49
Re: create table question - Hive - [mail # user]
...For exampleif ur name node was hadoop_name_nodeIP:8020(verify this thru your browser http://hadoop_name_nodeIP:50070)Modified Create Table==================CREATE EXTERNAL TABLE states(abbre...
   Author: Sanjay Subramanian, 2014-04-23, 04:32
Re: Query hangs at 99.97 % for one reducer in Hive - Hive - [mail # user]
...Even 500 reducers sounds a high number but I don't know the deatils of your cluster. Can u provide some detailsHow many nodes in cluster Hive version Which distribution (Hortonworks, Apache,...
   Author: Sanjay Subramanian, 2014-03-03, 00:43
Hive (123)
HDFS (10)
MapReduce (5)
Hadoop (2)
Spark (2)
Impala (1)
mail # user (122)
issue (1)
wiki (1)
last 7 days (3)
last 30 days (4)
last 90 days (4)
last 6 months (9)
last 9 months (124)
Namit Jain (645)
Carl Steinbach (416)
Brock Noland (401)
Zheng Shao (382)
Ashutosh Chauhan (351)
Edward Capriolo (297)
Navis (292)
Gunther Hagleitner (235)
Thejas M Nair (223)
Xuefu Zhang (220)
Lefty Leverenz (214)
John Sichi (212)
Ning Zhang (171)
Sergey Shelukhin (162)
Kevin Wilfong (152)
Thejas Nair (151)
Harish Butani (146)
He Yongqiang (139)
Jason Dere (139)
Eugene Koifman (125)
Szehon Ho (121)
Vaibhav Gumashta (118)
Nitin Pawar (113)
Alan Gates (111)
Eric Hanson (108)
Sanjay Subramanian