Wikimedia Bugzilla is closed!

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 :-)