Re: Create external table

yes but table then exists correct I mean second time did you try *use default;* *drop table if exists trips;* it is still within Hive metadata registered as an existing table. Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8

Re: Create external table

Hi Thanks for your answer. --- At first I create an empty hdfs directory (if directory is empty I did not have problems before too). [margusja@hadoopnn1 ~]$ hdfs dfs -mkdir /user/margusja/trips [margusja@hadoopnn1 ~]$ beeline -f create_externat_table_trips.hql -u "jdbc:hive2://hadoopnn1.ex

RE: Any difference between LOWER and LCASE

Hi According to documentation LCASE is a synonym for LOWER. From what I've seen in the source code, it seems right. https://github.com/apache/hive/blob/f089f2e64241592ecf8144d044bec8a0659ff422/ql/src/java/org/apache/hadoop/hive/ql/exec/FunctionRegistry.java system.registerGenericUDF("lower",

RE: Unsupported SubQuery Expression '1': Only SubQuery expressions that are top level conjuncts are allowed

You’re welcome Dudu From: mahender bigdata [mailto:mahender.bigd...@outlook.com] Sent: Wednesday, May 11, 2016 1:43 AM To: user@hive.apache.org Subject: Re: Unsupported SubQuery Expression '1': Only SubQuery expressions that are top level conjuncts are allowed Thanks Dudu, I made modification

Hive cte Alias problem

Hi, I see peculiar difference while querying using CTE where I'm aliasing one of column in table to another column name in same table. Instead of getting values of source column, hive returns NULLS i.e column 8 values withcte_temp as ( select a.COLUMN1, a.Column2,a.Column2 asColumn8,ID fr

Re: Create external table

Try this simple external table creation in beeline (check first that that it connects OK) *use default;drop table if exists trips;CREATE EXTERNAL TABLE `TRIPS`( `bike_nr` string, `duration` int, `start_date` string, `start_station` string, `end_station` string)PARTITIONED

Any difference between LOWER and LCASE

Hi Team, Is there any difference between LOWER and LCASE functions in Hive. For one of the query, when we are using LOWER in where condition, it is failing to match record. When we changed to LCASE, it started matching. I surprised to see differences in LOWER and LCASE. Can any one know why t

Re: Unsupported SubQuery Expression '1': Only SubQuery expressions that are top level conjuncts are allowed

Thanks Dudu, I made modification as per our requirement. ur query helped me to modify as per our requirement. On 5/4/2016 10:57 AM, Markovitz, Dudu wrote: Hi The syntax is not Hive specific but SQL ANSI/ISO. In a series of “JOIN … ON …” any “ON” can (but not necessarily have to) refer any

Re: Create external table

Hi again I opened hive (an old client) And exactly the same create external table location [paht in hdfs to place where are loads of files] works and the same DDL does not work via beeline. Margus (margusja) Roo http://margus.roo.ee skype: margusja +372 51 48 780 On 10/05/16 23:03, Mar

Create external table

Hi Can someone explain or provide documentation how Hive creates external tables? I have problem with creating external table in case I am pointing location in hdfs in to directory where are loads of files. Beeline just hangs or there will be other errors. In case I point location in to th