Displaying Images in SQL Tables in Zeppelin

[#1]

It's easier than I would have thought to add images to your SQL results tables in Apache Zeppelin.

It's pretty simple to do this in HDP 2.5's version of Apache Zeppelin. You use the %html tag to output HTML instead of text.

Use Case: Displaying Image with TensorFlow Inception Image Recognition Results in Same List

Example SQL:

SELECT user_name, handle, concat('%html <img width=50 height=60 src="', media_url, '">') as media,substring(inception,0,150) as inception, msg, sentiment, stanfordsentiment, location, time
FROM twitterorc where inception not like '%Not found%' and inception is not null and trim(inception)!= ''