'AWS KINISES Analytics Studio ZEPPELIN Flink HIVE error

I create a Studio Notebook at Kinesis analytics, I can see data come in by MQTT SQL Legacy of Analytics. So I am receiving data:

enter image description here

When I go to "open in apache zeppelin"

I create the table

 %flink.ssql 
 CREATE TABLE `ppgsignal0903` ( `timestamp` BIGINT,`[Heart Rate Measurement]` DOUBLE, 
 `[Energy Expended]` DOUBLE,
 `RR-Interval` DOUBLE, 
 `iso_time` as TO_TIMESTAMP(FROM_UNIXTIME(`timestamp`)) ) 
 WITH ( 'connector' = 'kinesis', 
 'stream' = 'PPG_PW',
 'aws.region' = 'eu-central-1',
 'scan.stream.initpos' = 'LATEST', 
 'format' = 'json' )

data is coming in all the time, when I go to see my table:

%flink.ssql(type=update)
SELECT * FROM   ppgsignal0903;

I have the following error:

Fail to run sql command: SELECT * FROM  ppgsignal0903
 Unable to create a source for reading table 
'hive.ppgdatabase.ppgsignal0903'.

Table options are:

'aws.region'='eu-central-1'
'connector'='kinesis'
'format'='json'
'scan.stream.initpos'='LATEST'
'stream'='PPG_PW'

does anyone have a tip?

I need to do some analytics and manipulate the data showing real time charts( for example, hear beats per second, time between diastolic and systolic blood pressure in the last 10 min, etc) , so I need to have different paragraphs where I could run separate with real time data



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source