| clear query|facets|time |
Search criteria: .
Results from 1 to 10 from
16 (0.665s).
|
|
|
Loading phrases to help you
refine your search...
|
|
RE: S3/EMR Hive: Load contents of a single file - Hive - [mail # user]
|
|
...No problem Keith - it was a worthwhile exercise for me to go back and double check everything was working as expected. From: Keith Wiley [mailto:[EMAIL PROTECTED]] Sent: ...
|
|
|
Author: Tony Burton,
2013-03-27, 17:18
|
|
|
RE: S3/EMR Hive: Load contents of a single file - Hive - [mail # user]
|
|
...A bit more info - do an extended description of the table: $ desc extended gsrc1; And the "location" field is "location:s3://mybucket/path/to/data/src1.txt" Do the same on ...
|
|
|
Author: Tony Burton,
2013-03-27, 09:58
|
|
|
RE: S3/EMR Hive: Load contents of a single file - Hive - [mail # user]
|
|
...Thanks for the reply Keith. Yep, but I have multiple files in that directory and wanted to create a table based upon one file per table. I've got two files in my s3://mybucket/...
|
|
|
Author: Tony Burton,
2013-03-27, 08:46
|
|
|
RE: S3/EMR Hive: Load contents of a single file - Hive - [mail # user]
|
|
...Also, it might be worth pointing out that despite what I've written in my create table statement, this table is not partitioned - just one set of data contained in one textfile on s3. So per...
|
|
|
Author: Tony Burton,
2013-03-26, 17:45
|
|
|
RE: S3/EMR Hive: Load contents of a single file - Hive - [mail # user]
|
|
...Thanks for the quick reply Sanjay. ALTER TABLE is the key, but slightly different to your suggestion. I create the table as before, but don't specify location: $ create external ...
|
|
|
Author: Tony Burton,
2013-03-26, 17:39
|
|
|
S3/EMR Hive: Load contents of a single file - Hive - [mail # user]
|
|
...Hi list, I've been using hive to perform queries on data hosted on AWS S3, and my tables point at data by specifying the directory in which the data is stored, eg $ create extern...
|
|
|
Author: Tony Burton,
2013-03-26, 17:11
|
|
|
RE: HWI use on AWS/EMR - Hive - [mail # user]
|
|
...Hi Nitin (and others who have contributed) Thanks again for the suggestions - however my original objective was to investigate HWI as an alternative to hive in CLI mode for less techie...
|
|
|
Author: Tony Burton,
2013-01-21, 16:37
|
|
|
RE: HWI use on AWS/EMR - Hive - [mail # user]
|
|
...Thanks for the suggestion Nitin. I can see the "Change Security Groups" option for my instance (when looking at the EC2 console), but it's greyed out. The only option I have on the EMR...
|
|
|
Author: Tony Burton,
2013-01-21, 13:13
|
|
|
RE: HWI use on AWS/EMR - Hive - [mail # user]
|
|
...I've tracked down this document on AWS: http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/authorizing-access-to-an-instance.html which shows how to create security groups to ass...
|
|
|
Author: Tony Burton,
2013-01-21, 11:39
|
|
|
RE: HWI use on AWS/EMR - Hive - [mail # user]
|
|
...If you could provide the steps to do this I'd be grateful - thanks. Thanks for all your input so far, time to head home for the weekend so I'll try it again with a fresh EMR instance n...
|
|
|
Author: Tony Burton,
2013-01-18, 17:17
|
|
|
|
