|| at Jun 3, 2013 at 7:40 pm
The original text file was uploaded to hdfs via the Hue file browser. Then
I used the 'create a new table from a file' link in the Metastore Manager
and followed the appropriate steps. When I look at the sample for the
table, it looks correct (all rows are separated correctly). I don't know
how I would upload the original text file via command line because I am
running Hadoop ontop of Amazon ec2 so I would first have to get the file
into ec2 somehow.
On Monday, June 3, 2013 3:25:52 PM UTC-4, Ricky Saltzer wrote:
Could you provide a little more information on this table? For example,
how was this table created and populated? Usually when you see all your
data in one column, it's because the field delimiter is incorrectly set and
so Impala (or Hive) is not able to correctly parse the columns.
Yeah, its taking forever, I don't think I can run this query. Any other
On Monday, June 3, 2013 2:57:31 PM UTC-4, Ricky Saltzer wrote:
Hey Alex -
I should have also probably asked if you can query this table in Hive
$ select * from <table_name> LIMIT 10;
How does the output look?
On Mon, Jun 3, 2013 at 2:55 PM, Alex Minnaar wrote:
The result of that is
# col_name data_type comment
one string None
two string None
three string None
four string None
five string None
# Detailed Table Information
CreateTime: Mon Jun 03 15:38:28 UTC 2013
Protect Mode: None
Table Type: MANAGED_TABLE
# Storage Information
SerDe Library: org.apache.hadoop.hive.**
Num Buckets: -1
Bucket Columns: 
Sort Columns: 
Storage Desc Params:
Time taken: 0.409 seconds
On Monday, June 3, 2013 2:42:02 PM UTC-4, Ricky Saltzer wrote:
Hey Alex -
Can you open up a Hive shell (*$ hive) *and perform an extended
describe on the table?
$ describe formatted <table_name>
$ describe extended <table_name>
The formatted table description is nicer to read...
On Mon, Jun 3, 2013 at 2:40 PM, Alex Minnaar wrote:
Ok disregard my last response. I was able to run it in the impala
shell and got the same result. All data was in the first column, the rest
On Monday, June 3, 2013 2:16:57 PM UTC-4, Udai wrote:
What do you see when you run the query on Impala shell?
On Mon, Jun 3, 2013 at 11:01 AM, Alex Minnaar wrote:
I have a table in my default database with 5 columns. When I look
at the sample in the Hue Metastore Manager it looks fine. However, when I
do a "select * from table" in the Impala query editor, the result has all
of the data squished into the first column and nothing in the remaining 4.
Can anyone tell me how to fix this?