| clear query|facets|time |
Search criteria: .
Results from 21 to 30 from
44 (0.109s).
|
|
|
Loading phrases to help you
refine your search...
|
|
Re: changing field delimiter for an existing table? - Hive - [mail # user]
|
|
...Thanks but that requires fixing the table schema. Actually, I haven't found a way to change the delimiters of an existing table (created with a LIKE statement). I did find a workaround. &nbs...
|
|
|
Author: Igor Tatarinov,
2012-05-12, 00:15
|
|
|
changing field delimiter for an existing table? - Hive - [mail # user]
|
|
...Is that possible? What I am trying to do is create an S3 table using CTAS. Since CTAS doesn't allow specifying a location, I have to create a managed table first: CREATE TABLE T ...
|
|
|
Author: Igor Tatarinov,
2012-05-11, 21:58
|
|
|
create external table as select with location? - Hive - [mail # user]
|
|
...Is it possible to do something like this: CREATE EXTERNAL TABLE T LOCATION 's3://...' AS SELECT ...; I would rather not fix the schema for T so that I can easily change the SELEC...
|
|
|
Author: Igor Tatarinov,
2012-04-04, 17:33
|
|
|
Re: order by having no effect?! - Hive - [mail # user]
|
|
...You have attributevalue in quotes which makes it a constant literal. igor decide.com On Tue, Mar 13, 2012 at 1:54 PM, Keith Wiley wrote: ...
|
|
|
Author: Igor Tatarinov,
2012-03-13, 20:57
|
|
|
Re: create table LIKE for external tables? - Hive - [mail # user]
|
|
...Thanks, I should have tried adding "external" before asking :) Although, it doesn't work in EMR Hive. Table B is still 'described' as managed so I had to run alter table B set tb...
|
|
|
Author: Igor Tatarinov,
2012-03-06, 06:39
|
|
|
create table LIKE for external tables? - Hive - [mail # user]
|
|
...Is there a way to create an external table LIKE another table? This doesn't work: CREATE TABLE B LIKE A ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE LOCATION...
|
|
|
Author: Igor Tatarinov,
2012-03-06, 00:59
|
|
|
Re: Last value for a column - Hive - [mail # user]
|
|
...I don't think there is a better way to implement your query using the standard SQL/Hive. A python reducer (or a java UDF) is the way to go. I don't think clustering would help si...
|
|
|
Author: Igor Tatarinov,
2012-01-26, 20:08
|
|
|
dropping an "external" table without deleting the data - Hive - [mail # user]
|
|
...I keep making the same mistake of creating an external table without saying "EXTERNAL". As a result, as you can imagine, I am stuck with a table that I cannot drop or I'll lose the external ...
|
|
|
Author: Igor Tatarinov,
2012-01-24, 23:54
|
|
|
Re: Performance problems with Hive script - Hive - [mail # user]
|
|
...To compute moving averages, you should implement a custom reducer instead of doing a big join. That will work *much* faster. Also, Hive already has date_add(). Why did you have to impl...
|
|
|
Author: Igor Tatarinov,
2012-01-24, 07:26
|
|
|
Re: Help with a table located on s3n - Hive - [mail # user]
|
|
...Also, in EMR the default file system for reading regular files is s3 rather than s3n (the latter is a block file system requiring its own bucket or something like that). Basically, s3 and s3...
|
|
|
Author: Igor Tatarinov,
2011-12-16, 06:48
|
|
|
|
