Re: Query in column name

If you are running Hive .13+, use *backticks*. {quote} create table x (`col name` string); No rows affected (0.148 seconds) select `col name` from x; {quote} You can refer to Hive wiki for details, https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL HTH, Youngwoo On Thu, Jun

Re: Full text index functionality available?

AFAIK, Hive does not support the built-in features like you mentioned. But using Hive storage handler, you can integrate other components that support data indexing and searching. For instance, there are storage handlers for Solr and ElasticSearch [1][2]. HTH Regards, Youngwoo [1].

Re: Hive insert into

Abhi, Hive supports INSERT INTO syntax but you should use Hive 0.8 or higher. See https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-InsertingdataintoHiveTablesfromqueries - Youngwoo On Wed, Jul 4, 2012 at 11:19 AM, Abhishek abhishek.dod...@gmail.com wrote:

Re: can hive support directory recursive in external localtion

Hi, It seems like the issue is not resolved. see https://issues.apache.org/jira/browse/HIVE-951 - Youngwoo On Wed, Aug 31, 2011 at 4:02 PM, Junxian Yan junxian@gmail.com wrote: Hi Guys I stored the production log files in folders which are named as the date. the structured look like

Re: Hive 0.7 thrift server thread safety

Tommy, I found a link for that. See http://oobaloo.co.uk/multiple-connections-with-hive HTH, - Youngwoo On Tue, Aug 30, 2011 at 4:12 AM, Tommy Li tommyli...@gmail.com wrote: Hi all, Is the thrift server thread safe? Will a single instance be able to serve multiple client side JDBC

Re: Question about create hive tables.

Hi dujinhang, See, http://wiki.apache.org/hadoop/Hive/UserGuide add jar ../build/contrib/hive_contrib.jar; CREATE TABLE apachelog ( host STRING, identity STRING, user STRING, time STRING, request STRING, status STRING, size STRING, referer STRING, agent STRING) ROW FORMAT

Re: how to invoke hive command line client?

/26 김영우 warwit...@gmail.com See, http://wiki.apache.org/hadoop/Hive/HiveClient http://wiki.apache.org/hadoop/Hive/HiveClient- Youngwoo 2011/5/26 jinhang du dujinh...@gmail.com Hi all, I want to create a lot of tables and load data separately. These tables need different parameters. So

HiveQL for 'rank() over (partition by ... order by ...)'?

Hi All, I'm trying to convert Oracle SQL to HiveQL, esp Oracle Analytic functions. Is it possible to implement using Hive UDFs or workarounds? I would like to hear your experiences and advice. Thanks in advance. - Youngwoo

Re: how to invoke hive command line client?

See, http://wiki.apache.org/hadoop/Hive/HiveClient http://wiki.apache.org/hadoop/Hive/HiveClient- Youngwoo 2011/5/26 jinhang du dujinh...@gmail.com Hi all, I want to create a lot of tables and load data separately. These tables need different parameters. So I want to use python for

Re: Using PostgreSQL as Hive metastore

Hi Mike, It seems like there are some problems on creating metastore schema. So, create a schema for hive metastore first and then try it again. There is a DDL script for Pg, http://svn.apache.org/repos/asf/hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.7.0.postgres.sql - Youngwoo

Re: Hive 7

Hi soumya, I think 'Hive Wiki' is a good start point for you. See http://wiki.apache.org/hadoop/Hive http://wiki.apache.org/hadoop/Hive- Youngwoo 2011/4/13 soumya mishra psuedop...@gmail.com Hello, I have to use Hive 7 for a project so wanted to know some details about it and also if some

Re: Associative Arrays in Hive?

Refer to this http://dev.bizo.com/2011/02/columns-in-hive.html http://dev.bizo.com/2011/02/columns-in-hive.htmlHTH - Youngwoo 2011/3/2 Sunderlin, Mark mark.sunder...@teamaol.com Let us say my log data that I want to place a log file into hive. And the log file itself looks something like

Re: what char represents NULL value in hive?

Hi LiuLei, You should use '\N' for null in your data files. - Youngwoo 2011/1/21 lei liu liulei...@gmail.com I generate HDFS file , then I load the file to one hive table. There are some colums are don't have value, I need to set these colums to NULL. I want to know what char represents

Re: Find a case that does not make sense in hive

. 3. can see data file in hadoop, but if u query hive, u can't access that. It's a bug Thanks and Regards Vaibhav Negi On Fri, Jan 7, 2011 at 3:17 PM, 김영우 warwit...@gmail.com wrote: Hi Jeff, How could you insert data into a partitioned table without specify partition columns or value

Re: which thrift version hive0.6 use?

Hi LiuLei, I don't believe that Hive 0.6 use Thrift 0.5. In Hive 0.7(trunk) The Thrift is bumped up to release version (0.5). see details https://issues.apache.org/jira/browse/HIVE-1526 https://issues.apache.org/jira/browse/HIVE-1526- Youngwoo 2011/1/5 lei liu liulei...@gmail.com Now there is

Re: Hive connection issues on CDH3b3

Hi ray, https://issues.apache.org/jira/browse/HIVE-1264 You should upgrade Hive to 0.7(trunk). CDH3beta3 includes hadoop security features. - Youngwoo 2010/10/25 Ray Duong ray.du...@gmail.com Hi, I'm getting the following error message after upgrading to CDH3b3. Does anyone know how to