How to plan the Hive flow meter

Editor to share with you how to plan the Hive flow table, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Create EXTERNAL table IF NOT EXISTS ext_clicklog (

CookieId string COMMENT 'cookieId Nginx server assignment, for example: 05dvOVC6Il6INhYABV6LAGUBV6

Cate1 string COMMENT 'first-level performance category, example: real estate'

Cate2 string COMMENT 'level 2 performance category, example: xx'

Cate3 string COMMENT 'level 3 performance classification, example: xx'

Area1 string COMMENT 'first-level performance region: Beijing (City)'

Area2 string COMMENT 'second-level performance region: region'

Area3 string COMMENT 'third-level performance region: business area'

PageType string COMMENT 'level 1 page type list detail ect'

Page string COMMENT 'secondary page type'

Url string COMMENT 'url address of the page for this browsing activity'

TrackTime string COMMENT 'user visit time: 2014-05-25 23 0315 36'

UserIp string COMMENT 'user visits the IP address this time; 175.153.41.6'

LoginUid string COMMENT 'login user ID'

Referer string COMMENT 'referer URL: the source URL' of the current page

Fromtag string COMMENT 'fromtag burial site name'

TrackURLMap map COMMENT 'variable length fields, some custom fields:

Platform string COMMENT'is the log of which platform: pc/m/app'

UrlParamMap map COMMENT 'url parameter map'

) PARTITIONED BY (statDate STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY'\ 001' COLLECTION ITEMS TERMINATED BY'\ 002' MAP KEYS TERMINATED BY'\ 003' LINES TERMINATED BY'\ n 'STORED AS TEXTFILE LOCATION' / DataWarehouse/ods/ClickLogTable'

The above is all the contents of the article "how to Plan the Hive flow Table". Thank you for your reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!