https://bugzilla.wikimedia.org/show_bug.cgi?id=73095
Bug ID: 73095
Summary: Switching column type of time_firstbyte broke the
table
Product: Analytics
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: Refinery
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected],
[email protected], [email protected],
[email protected], [email protected],
[email protected], [email protected]
Web browser: ---
Mobile Platform: ---
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 :-)
--
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
