Thx. Please see below create table SQL
carbon.sql("create table carbon_test_new_7(flowSeqNum integer ,protocolId
integer ,srcTos integer ,dstTos integer ,tcpBits integer ,srcPort integer
,dstPort integer ,workerId integer ,epoch long ,rowNum long ,exportMs long
,pktSeqNum long ,inIfId long ,inIfEntityId long ,outIfId long ,outIfEntityId
long ,inOctets long ,outOctets long ,inPackets long ,outPackets long
,bgpSrcAsNum long ,bgpDstAsNum long ,endMs long ,startMs long
,policyQosQueueId long ,exporterIp string ,srcIp string ,dstIp string
,srcMask string ,dstMask string ,direction string ,nextHopIp string
,bgpNextHopIp string ,appName string ,srcIpGroup string ,dstIpGroup string
,appId string ,policyQosClassificationHierarchy string ,inIfEnabled boolean
,outIfEnabled boolean) stored as carbondata
TBLPROPERTIES('INVERTED_INDEX'='inIfId,dstIpGroup,appName')")
").show()
Also, the queries we use are like select appName, sum(inPackets),
sum(inPackets) from carbon_test_new7 group by inIfid, appName
Also, when we are creating datamaps on above table for specific queries (we
have where condition in it) using EXPLAIN command we are not coming to know
whether it is using datamap or main table only.
Please help in having what columns to include in DICTIONARY, INVERTED index,
sorted columns and datamap creations.
BR,
Deepak
--
Sent from:
http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/
