[ https://issues.apache.org/jira/browse/IMPALA-4107?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
John Russell resolved IMPALA-4107. ---------------------------------- Resolution: Fixed The gerrit was finalized and the restriction is now in the docs. > APPX_MEDIAN cuts string to 10 chars > ----------------------------------- > > Key: IMPALA-4107 > URL: https://issues.apache.org/jira/browse/IMPALA-4107 > Project: IMPALA > Issue Type: Bug > Components: Docs > Affects Versions: Impala 2.6.0 > Reporter: Peter Brejcak > Assignee: Alex Rodoni > Priority: Minor > > Function APPX_MEDIAN returns only first 10 characters for string input. I > didn't find such restrictions in documentation. > Expected result for code below should be that > length(APPX_MEDIAN(t.value))>=min(length(t.value)) but real result is > different > Please let me know if anything is not clear > {code} > create table user_agents (id int, value string); > insert into table user_agents values (1,'Mozilla/5.0 (compatible; > Googlebot/2.1; +http://www.google.com/bot.html)'); > insert into table user_agents values (2,'Mozilla/5.0 (Windows NT 6.3) > AppleWebKit/537.36 (KHTML; like Gecko) Chrome/44.0.2441.18 Safari/537.36'); > insert into table user_agents values (3,'Mozilla/5.0 (Windows NT 6.3; Win64; > x64) AppleWebKit/537.36 (KHTML; like Gecko) Chrome/39.0.2186.5 > Safari/537.36'); > insert into table user_agents values (4,'Mozilla/5.0 (Windows NT 6.3; WOW64) > AppleWebKit/537.36 (KHTML; like Gecko) Chrome/33.0.1810.81 Safari/537.36'); > insert into table user_agents values (5,'Mozilla/5.0 (Windows NT 6.3; WOW64) > AppleWebKit/537.36 (KHTML; like Gecko) Chrome/33.0.1810.81 Safari/537.36'); > insert into table user_agents values (6,'Mozilla/5.0 (Windows NT 5.1; WOW64) > AppleWebKit/537.36 (KHTML; like Gecko) Chrome/33.0.1828.68 Safari/537.36'); > insert into table user_agents values (7,'Mozilla/5.0 (Linux; U; Android > 4.1.2; en-us; GT-I8190 Build/JZO54K) AppleWebKit/534.30 (KHTML; like Gecko) > Version/4.0 Mobile Safari/534.30 [FB_IAB/FB4A;FBAV/74.0.0.21.69;]'); > insert into table user_agents values (8,'Mozilla/5.0 (Windows NT 6.1; WOW64) > AppleWebKit/537.36 (KHTML; like Gecko) Chrome/32.0.1713.94 Safari/537.36'); > insert into table user_agents values (9,'Mozilla/5.0 (Windows NT 6.3; Win64; > x64) AppleWebKit/537.36 (KHTML; like Gecko) Chrome/44.0.2421.69 > Safari/537.36'); > select count(1), APPX_MEDIAN(value), length(APPX_MEDIAN(t.value)), > min(length(t.value)) from user_agents t > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)