Page MenuHomePhabricator

Switching column type of time_firstbyte broke the table
Closed, ResolvedPublic

Description

Updating the time_firstbyte column from float to double (bug 73018) using a plain

ALTER TABLE webrequest CHANGE time_firstbyte time_firstbyte double;

succeeded without an error, but afterwards, it was no longer possible to
select data:

hive (wmf_raw)> select * from webrequest where webrequest_source='mobile' and year=2014 and month=11 and day=6 and hour=10 limit 2;
OK
hostname        sequence        dt      time_firstbyte  ip      cache_status    http_status     response_size   http_method     uri_host        uri_path        uri_query       content_type    referer x_forwarded_for user_agent      accept_language        x_analytics     webrequest_source       year    month   day     hour
Failed with exception java.io.IOException:org.apache.hadoop.hive.ql.metadata.HiveException: Error evaluating hostname

Hive does not like us :-)


Version: unspecified
Severity: normal

Details

Reference
bz73095

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 3:54 AM
bzimport set Reference to bz73095.
bzimport added a subscriber: Unknown Object (MLST).

I rebuilt the webrequest table and added all partitions again.
Now selecting again works as expected.