I'm using Cygnus to send Orion Context Broker notifications to Cosmos via httpfs.
Where are stored the data sent to Cosmos in the Hive history? What's the name of the table where Cygnus data are stored?
I'm using Cygnus to send Orion Context Broker notifications to Cosmos via httpfs.
Where are stored the data sent to Cosmos in the Hive history? What's the name of the table where Cygnus data are stored?
The Orion context data persisted by Cygnus in Cosmos is stored in plain text HDFS files. The content of this files, if properly structured, can be loaded into Hive tables which can be queried by using HiveQL, a SQL-like language.
The way the Hive tables are created depends on the Cygnus version you are using:
hive
create external table <table_name> (recvTimeTs bigint, recvTime string, entityId string, entityType string, attrName string, attrType string, attrValue string) row format delimited fields terminated by '|' location '/user/<myusername>/<mydataset>/';
<myusername>_<mydataset>
. As in Cygnus 0.1, all the entities data is stores within the same and unique Hive table.