Query the Hive table
Query the Hive table to verify that the CDC data is being captured:
hive> select * from oraclehive; OK {"3":"0","2":"6705362103919221351","1":"D6RJPwyuLXoLqQRQcOcouJ26KGxJSf6hgbu", "10":"Quicksand","0":"COMPANY 1","6":"USD","5":"0916","4":"20130309113025","9":"41363", "8":"5150279519809946"} NULL {"TxnID":"10.23.1524","RbaSqn":"209", "TableSpace":"USERS","CURRENTSCN":"1939875","OperationName":"INSERT", "ParentTxnID":"10.23.1524","SegmentType":"TABLE","SessionInfo":"UNKNOWN", "ParentTxn":"QATEST","Session":"143","BytesProcessed":"760", "TransactionName":"","STARTSCN":"","SegmentName":"POSAUTHORIZATIONS","COMMITSCN":"", "SEQUENCE":"1","RbaBlk":"57439","ThreadID":"1","SCN":"193987500000588282738968494240000", "AuditSessionId":"73401","ROWID":"AAAXlEAAEAAAALGAAA", "TimeStamp":"2015-10-08T14:58:55.000-07:00","Serial":"685", "RecordSetID":" 0x0000d1.0000e05f.0010 ","TableName":"QATEST.POSAUTHORIZATIONS", "SQLRedoLength":"325","Rollback":"0"} {"3":"4","2":"4710011837121304048","1":"OFp6pKTMg26n1iiFY00M9uSqh9ZfMxMBRf1", "10":"Westfield","0":"COMPANY 2","6":"USD","5":"0815","4":"20130309113025","9":"16950", "8":"5985180438915120"} NULL {"TxnID":"10.23.1524","RbaSqn":"209", "TableSpace":"USERS","CURRENTSCN":"1939876","OperationName":"INSERT", "ParentTxnID":"10.23.1524","SegmentType":"TABLE","SessionInfo":"UNKNOWN", "ParentTxn":"QATEST","Session":"143","BytesProcessed":"762", "TransactionName":"","STARTSCN":"","SegmentName":"POSAUTHORIZATIONS","COMMITSCN":"", "SEQUENCE":"1","RbaBlk":"57441","ThreadID":"1","SCN":"193987600000588282738969804960001", "AuditSessionId":"73401","ROWID":"AAAXlEAAEAAAALGAAB", "TimeStamp":"2015-10-08T14:58:56.000-07:00","Serial":"685", "RecordSetID":" 0x0000d1.0000e061.0010 ","TableName":"QATEST.POSAUTHORIZATIONS", "SQLRedoLength":"327","Rollback":"0"} ... Time taken: 0.238 seconds, Fetched: 11 row(s)
To select a subset of the data, use syntax similar to the following:
hive> select metadata["TimeStamp"], metadata["TxnID"], metadata["TableName"], data from orclehive where metadata["OperationName"]="UPDATE"; 2015-10-08T14:58:56.000-07:00 5.26.1740 QATEST.POSAUTHORIZATIONS {"0":"COMPANY 1A","1":"D6RJPwyuLXoLqQRQcOcouJ26KGxJSf6hgbu"} 2015-10-08T14:58:56.000-07:00 5.26.1740 QATEST.POSAUTHORIZATIONS {"0":"COMPANY 2A","1":"OFp6pKTMg26n1iiFY00M9uSqh9ZfMxMBRf1"} ... Time taken: 0.088 seconds, Fetched: 5 row(s)