Re: Data Modeling Tool

2014-03-06 Thread Joseph D Antoni
A data architect friend said the latest release of CA Erwin can handle Hive, but it doesn't support Postgres directly. Thanks Joey D'Antoni On Wednesday, March 5, 2014 9:59 PM, Ronak Bhatt wrote: Hello Hive Experts Is there any data modeling tool that you can suggest that can work with Hi

Hive ODBC Error

2013-12-04 Thread Joseph D Antoni
To all, I'm trying to connect Tableau to Hive (0.10.0) running Hiveserver2. The connection works ok, until I go to pull in the data. The resulting M/R job is attempting to connect to port 8021 on one of my data nodes--I've tried both Cloudera and Hortonworks ODBC in an effort to rule that out,

Re: CREATE EXTERNAL TABLE Fails on Some Directories

2013-02-15 Thread Joseph D Antoni
supergroup    7853975 2013-02-14 17:03 /715 [cloudera@localhost data]$ hdfs dfs -ls 715 Found 13 items -rw-r--r--   1 cloudera cloudera    7853975 2013-02-15 00:41 715/40-file.csv Thanks From: Dean Wampler To: user@hive.apache.org; Joseph D Antoni Sent

Re: CREATE EXTERNAL TABLE Fails on Some Directories

2013-02-15 Thread Joseph D Antoni
To: user@hive.apache.org; Joseph D Antoni Sent: Friday, February 15, 2013 11:37 AM Subject: Re: CREATE EXTERNAL TABLE Fails on Some Directories You confirmed that 715 is an actual directory? It didn't become a file by accident? By the way, you don't need to include the file name in t

CREATE EXTERNAL TABLE Fails on Some Directories

2013-02-15 Thread Joseph D Antoni
I'm trying to create a series of external tables for a time series of data (using the prebuilt Cloudera VM). The directory structure in HDFS is as such: /711 /712 /713 /714 /715 /716 /717 Each directory contains the same set of files, from a different day. They were all put into HDFS using the