wso2bam - WSO2 - Table created using Analytic Script Invisible in Gadget Generation Tool -
The case of my use: pushing data from a stream BAM configured in ESB and using a report ???? Gadget creation tool
After adding an agent to the proxy service, BAM publishes the stream from ESB to work properly.
From the stream I created from a table using Analytics-> Add to the screen and apply the table as it seems to me to select one and see the result from the same screen
Now I have to generate a dashboard using the gadget generation tool But the table is not trying. Available, although the JDBC connection is working well, but the table is nowhere:
Analytics-> script to run analytic table from the screen
Create an external table Not existing CREDITTABLE (creditkey STRING, creditFlag STRING, version string) SERDEPROPERTIES ("cassandra.host" = '127.0.0.1 "with' org.apache.hadoop.hive.cassandra.CassandraStorageHandler 'stored cassandra.port" = "9163 "," Cassandra.ks.name "=" EVENT_S "," cassandra.ks.username "=" admin "," cassandra.ks.password "=" admin "," cassandra.cf.name "=" firststream " , "Cassandra.columns. Mapping "=": key, 1-continuous version of payload_ "); tried to search the table in the following database: jdbc: h2: repository / database / wsoccrdbndb; aUTO_SERVER = TRUE Jdbc: h2: repository / database / metastore_db; aUTO_SERVER = TRUE jdbc: h2: repository / database / samples / BAM_STATS_DB; AUTO_SERVER = TRUE No custom DB configuration has been done.
You tried JDBC: H2: stores / database / samples / WSO2CARBON_DB; AUTO_SERVER = true ? Besides, what you have pasted is the cassandra storage definition, which is probably used to get input, not to continue output. If you give a full hive query, it will help to understand the problem further.
Comments
Post a Comment