RE: Stopping HiveServer2

2015-04-29 Thread CHEBARO Abdallah
Typed ‘hiveserver2’ in my terminal From: Nitin Pawar [mailto:nitinpawar...@gmail.com] Sent: Wednesday, April 29, 2015 2:01 PM To: user@hive.apache.org Subject: Re: Stopping HiveServer2 how did you start it ? On Wed, Apr 29, 2015 at 4:26 PM, CHEBARO Abdallah mailto:abdallah.cheb...@murex.com

Stopping HiveServer2

2015-04-29 Thread CHEBARO Abdallah
Hello, How can I stop hiveserver2? I am not able to find the command. Thanks *** This e-mail contains information for the intended recipient only. It may contain proprietary material or confidential information. If you are not the intended recipient you are not auth

External table

2014-09-04 Thread CHEBARO Abdallah
Hello, Is it possible to create an external table and point it to a file instead of a directory? thanks *** This e-mail contains information for the intended recipient only. It may contain proprietary material or confidential information. If you are not the intende

RE: Hive columns

2014-09-04 Thread CHEBARO Abdallah
to create proper tables from these files and then use hive to do more deeper analytics On Thu, Sep 4, 2014 at 6:35 PM, CHEBARO Abdallah mailto:abdallah.cheb...@murex.com>> wrote: Can you please specify what this means? From: Nitin Pawar [mailto:nitinpawar...@gmail.com<mailto:nitinpawar.

RE: Hive columns

2014-09-04 Thread CHEBARO Abdallah
, Sep 4, 2014 at 6:13 PM, CHEBARO Abdallah mailto:abdallah.cheb...@murex.com>> wrote: Hello, Is it possible to create an external table without specifying the columns? In fact, I am creating an external table that points to a directory that contains 3 text file, and each text file has dif

Hive columns

2014-09-04 Thread CHEBARO Abdallah
Hello, Is it possible to create an external table without specifying the columns? In fact, I am creating an external table that points to a directory that contains 3 text file, and each text file has different number of columns. Thanks *** This e-mail contains infor

RE: Deleted data

2014-09-02 Thread CHEBARO Abdallah
the data from that location, but if you drop the table, the data is not deleted. Please see here for more specific information: https://www.inkling.com/read/hadoop-definitive-guide-tom-white-3rd/chapter-12/tables Ana On 2 September 2014 16:16, CHEBARO Abdallah mailto:abdallah.cheb...@murex.com

Deleted data

2014-09-02 Thread CHEBARO Abdallah
I had text file on HDFS, then I created tables in Hive, and loaded these data to the tables. When I dropped the tables, the data was lost. Any idea why? Thanks *** This e-mail contains information for the intended recipient only. It may contain proprietary material o

Where does hive store its data?

2014-09-02 Thread CHEBARO Abdallah
I can see that Hive stores the tables in hdfs/user/hive/warehouse, but I need to access the data from the disk. Where does Hive stores the data on the disk? Thanks *** This e-mail contains information for the intended recipient only. It may contain proprietary materi

RE: Distribution of Data

2014-08-26 Thread CHEBARO Abdallah
would not be overwrite by your code On Aug 26, 2014 7:07 PM, "CHEBARO Abdallah" mailto:abdallah.cheb...@murex.com>> wrote: What does it mean my replication have set as final? From: hadoop hive [mailto:hadooph...@gmail.com<mailto:hadooph...@gmail.com>] Sent: Tuesday, August 26,

RE: Distribution of Data

2014-08-26 Thread CHEBARO Abdallah
ug 26, 2014 6:46 PM, "CHEBARO Abdallah" mailto:abdallah.cheb...@murex.com>> wrote: This question is not directly related to Hive, but: I configured 3 datanodes on my Linux machine. In my configuration, I configured the number of replication to be 1. I am submitting a file to the

Distribution of Data

2014-08-26 Thread CHEBARO Abdallah
This question is not directly related to Hive, but: I configured 3 datanodes on my Linux machine. In my configuration, I configured the number of replication to be 1. I am submitting a file to the hdfs, and found that the file has 3 copies on each datanodes (I checked it from the browser) Isn'

Data in Hive

2014-08-14 Thread CHEBARO Abdallah
My target is to perform a SELECT query using Hive When I have a small data on a single machine (namenode), I start by: 1-Creating a table that contains this data: create table table1 (int col1, string col2) 2-Loading the data from a file path: load data local inpath 'path' into table table1; 3-P

RE: Distributed data

2014-08-12 Thread CHEBARO Abdallah
Tue, Aug 12, 2014 at 5:58 PM, CHEBARO Abdallah mailto:abdallah.cheb...@murex.com>> wrote: Yes I mean the data is on hdfs like filesystem From: Nitin Pawar [mailto:nitinpawar...@gmail.com<mailto:nitinpawar...@gmail.com>] Sent: Tuesday, August 12, 2014 3:26 PM To: user@hive.apache.org

RE: Distributed data

2014-08-12 Thread CHEBARO Abdallah
supports import/export with tools like sqoop then you can use them as well On Tue, Aug 12, 2014 at 5:58 PM, CHEBARO Abdallah mailto:abdallah.cheb...@murex.com>> wrote: Yes I mean the data is on hdfs like filesystem From: Nitin Pawar [mailto:nitinpawar...@gmail.com<mailto:n

RE: Distributed data

2014-08-12 Thread CHEBARO Abdallah
filesystem ? On Tue, Aug 12, 2014 at 5:51 PM, CHEBARO Abdallah mailto:abdallah.cheb...@murex.com>> wrote: Hello, Using Hive, we know that we should specify the file path to read data from a specific location. If the data is distributed on many computers, how can we read it?

Distributed data

2014-08-12 Thread CHEBARO Abdallah
Hello, Using Hive, we know that we should specify the file path to read data from a specific location. If the data is distributed on many computers, how can we read it? Thanks *** This e-mail contains information for the intended recipient only. It may contain prop

RE: Input

2014-07-31 Thread CHEBARO Abdallah
string and not abc only. Take a look at csv fileformat if you want to use proper comma delimited feature On Thu, Jul 31, 2014 at 3:44 PM, CHEBARO Abdallah mailto:abdallah.cheb...@murex.com>> wrote: Hello, I am using Hive and trying to read from a txt file. I have an input like the fo

Input

2014-07-31 Thread CHEBARO Abdallah
Hello, I am using Hive and trying to read from a txt file. I have an input like the following: "string";"string";"integer". First, I specified that the row fields are delimited by a semi-column. Is it possible to read the integer without the quotations? Thank you **

RE: Hive Data

2014-07-30 Thread CHEBARO Abdallah
uot; key if you have a csv file then you can use a csv serde. there are lots of such file formats. what does your file look like? On Wed, Jul 30, 2014 at 5:54 PM, CHEBARO Abdallah mailto:abdallah.cheb...@murex.com>> wrote: Hello, I am interested in testing Hive with a huge sample dat

RE: Hive Data

2014-07-30 Thread CHEBARO Abdallah
ats. what does your file look like? On Wed, Jul 30, 2014 at 5:54 PM, CHEBARO Abdallah mailto:abdallah.cheb...@murex.com>> wrote: Hello, I am interested in testing Hive with a huge sample data. Does Hive read all data types? Should the file be a table? Thank you ***

Hive Data

2014-07-30 Thread CHEBARO Abdallah
Hello, I am interested in testing Hive with a huge sample data. Does Hive read all data types? Should the file be a table? Thank you *** This e-mail contains information for the intended recipient only. It may contain proprietary material or confidential information

RE: SELECT specific data

2014-07-30 Thread CHEBARO Abdallah
mapping your partial column file as an external table. regards Devopam On Wed, Jul 30, 2014 at 2:49 PM, CHEBARO Abdallah mailto:abdallah.cheb...@murex.com>> wrote: I am only using Hive and hadoop, nothing more. From: Devopam Mittra [mailto:devo...@gmail.com<mailto:devo...@gmail.c

RE: SELECT specific data

2014-07-30 Thread CHEBARO Abdallah
options available to you are 1) simple unix tools like awk or sed or cut 2) write a pig script 3) write your own mapreduce code On Wed, Jul 30, 2014 at 3:09 PM, CHEBARO Abdallah mailto:abdallah.cheb...@murex.com>> wrote: “With hive, without creating a table with full data, you can do interm

RE: SELECT specific data

2014-07-30 Thread CHEBARO Abdallah
l data, you can do intermediate processing like select only few columns and write into another table, If this is something one time then you can take a look at awk or cut commands in linux and generate those files only. On Wed, Jul 30, 2014 at 2:49 PM, CHEBARO Abdallah mailto:abdalla

RE: SELECT specific data

2014-07-30 Thread CHEBARO Abdallah
, then please explore unix file processing/external table route. On Wed, Jul 30, 2014 at 2:09 PM, CHEBARO Abdallah mailto:abdallah.cheb...@murex.com>> wrote: Hello, Thank you for your reply. Consider we have data divided into 5 columns (col1, col2, col3, col4, col5). So I can’t load di

RE: SELECT specific data

2014-07-30 Thread CHEBARO Abdallah
, CHEBARO Abdallah mailto:abdallah.cheb...@murex.com>> wrote: Hello, I am interested in selecting specific data from a source and loading it to a table. For example, if I have 5 columns in my dataset, I want to load 3 columns of it. Is it possible to do it without create a second table?

SELECT specific data

2014-07-30 Thread CHEBARO Abdallah
Hello, I am interested in selecting specific data from a source and loading it to a table. For example, if I have 5 columns in my dataset, I want to load 3 columns of it. Is it possible to do it without create a second table? Thank you *** This e-mail contains infor

ERROR in JDBC

2014-07-18 Thread CHEBARO Abdallah
Hello Hive Community, I am trying to run the JDBC (from cwiki.apache.org), using HiveServer2. Everything in the Java code (attached above) runs well except for the last query: sql = "select * from " + tableName; Attached is the complete log file of several runs. I have noticed the following er

ERROR in JDBC

2014-07-17 Thread CHEBARO Abdallah
Hello Hive Community, I am trying to run the JDBC (from cwiki.apache.org), using HiveServer2. Everything in the Java code (attached above) runs well except for the last query: sql = "select * from " + tableName; Attached is the complete log file of several runs. I have noticed the following er

ERROR in JDBC

2014-07-17 Thread CHEBARO Abdallah
Hello Hive Community, I am trying to run the JDBC (from cwiki.apache.org), using HiveServer2. Everything in the Java code (attached above) runs well except for the last query: sql = "select * from " + tableName; Attached is the complete log file of several runs. I have noticed the following er

ERROR in JDBC

2014-07-17 Thread CHEBARO Abdallah
Hello Hive Community, I am trying to run the JDBC (from cwiki.apache.org), using HiveServer2. Everything in the Java code (attached above) runs well except for the last query: sql = "select * from " + tableName; Attached is the complete log file of several runs. I have noticed the following er

ERROR in JDBC

2014-07-17 Thread CHEBARO Abdallah
Hello Hive Community, I am trying to run the JDBC (from cwiki.apache.org), using HiveServer2. Everything in the Java code (attached above) runs well except for the last query: sql = "select * from " + tableName; Attached is the complete log file of several runs. I have noticed the following er