Community Articles

Find and share helpful community-sourced technical articles.
Labels (1)
Super Guru

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)!= ''



Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.
Version history
Last update:
‎08-17-2019 08:17 AM
Updated by:
Top Kudoed Authors