I am trying to run a query in both Hue and beeline, which is returning 0 rows (unexpected behavior). Earlier this week, I was trying to execute an ALTER statement in the same database, which generated a permissions error:
Permission denied: user=eyener, access=WRITE, inode="/wmf/data/raw/eventlogging/eventlogging_CentralNoticeBannerHistory/hourly/2019/12/02"
Usage: Following instructions outlined by a former Fundraising Analytics member found in the following wiki to test the transfer of banner history data for the Big English campaign
SELECT json_string FROM centralnoticebannerhistory20191202 where year = 2019 and month = 12
and day = 02 and hour = 1;
ALTER TABLE CentralNoticeBannerHistory20191202
ADD PARTITION (year=2019, month=12, day=02, hour=00)
Please let me know if you need any additional information, and thank you for the help.