Jul 23, 2013 · I have installed Hadoop, Hive, Hive JDBC. which are running fine for me. But I still have a problem. How to delete or update a single record using Hive because delete or update …

How can I use In clause in Hive I want to write something like this in Hive select x from y where y.z in (select distinct z from y) order by x; But I am not finding any way of doing it.. I tried...

I have a string column description in a hive table which may contain tab characters '\\t', these characters are however messing some views when connecting hive to an external application. …

Jan 27, 2014 · from hive_service import ThriftHive Next the port in the example was 10000, which when I tried caused the program to hang. The default Hive Thrift port is 9083, which stopped …

Sep 18, 2012 · hive> set tablename=newtable; hive> select * from ${tablename} -- uses 'newtable' vs hive> select * from ${hivevar:tablename} -- still uses the original 'mytable' Probably doesn't …

Dec 3, 2010 · Hive cast string to date dd-MM-yyyy Asked 10 years, 2 months ago Modified 3 years, 4 months ago Viewed 296k times

Dec 11, 2012 · After adding a partition to an external table in Hive, how can I update/drop it?

Dec 16, 2015 · I know we can load parquet file using Spark SQL and using Impala but wondering if we can do the same using Hive. I have been reading many articles but I am still confused. …

hive > LOAD DATA LOCAL INPATH '/tmp/hive-parsing-json.json' INTO TABLE hive_parsing_json_table; Query the table :

I'm using HiveContext with SparkSQL and I'm trying to connect to a remote Hive metastore, the only way to set the hive metastore is through including the hive-site.xml on the classpath (or …