0:jdbc:hive2://mini01:10000> SELECT * from session limit 10; +----------------+-----------------------------------+--------------------------+--------------------+--------- --------------------------------------------------------------+----------------------------+------------------- ---------+-------------------+-------------------------------+-----------------------+------------------------- ----+----------------------------+------------------------------------+-----------------+---------------------- +------------------+------------------+-------------------+-------------+---------------------+---------------- ---+--+
| Session.appid | Session.appkey | Session.application_ver | Session.channelid | session.session_id | session.local_time_string | session.local_date_string | session.duration | session.terminal_id | Session.device_model | Session.device_manufacture | session.device_resolution | Session.device_cpu | session.access | Session.access_type | Session.carrier | Session.country | Session.language | Session.os | session.os_version |
Session.timezone | +----------------+-----------------------------------+--------------------------+--------------------+--------- --------------------------------------------------------------+----------------------------+------------------- ---------+-------------------+-------------------------------+-----------------------+------------------------- ----+----------------------------+------------------------------------+-----------------+---------------------- +------------------+------------------+-------------------+-------------+---------------------+---------------- ---+--+
| 10391 | 14677915459507539AA11E10150E4B25 | 1.0.2.26961 | Digital Home Android | 20170225164024813_14:3E:BF:FF:94:49_14677915459507539AA11E10150E4B25 | 20170225165722191 | 20170225 | 8108 | 4952511019810210210257525257 | nx513j | Nubia | 1920*1080 | AArch64 Processor Rev 1 (aarch64) | Wi-Fi | Unknown | Orange | Unknown | Unknown | Android | 5.1.1 | 8 | | 10391 | 14677915459507539AA11E10150E4B25 | 1.0.2.26961 | Digital Home Android | 20170225165722192_14:3E:BF:FF:94:49_14677915459507539AA11E10150E4B25 | 20170225165726952 | 20170225 | 4559 | 4952511019810210210257525257 | nx513j | Nubia | 1920*1080 | AArch64 Processor Rev 1 (aarch64) | Wi-Fi | Unknown | Orange | Unknown | Unknown | Android | 5.1.1 | 8 | | 10391 | 14677915459507539AA11E10150E4B25 | 1.0.2.26961 | Digital Home Android | 20170225165726953_14:3e:bf: FF:94:49_14677915459507539AA11E10150E4B25 | 20170225165734705 | 20170225 | 7396 | 4952511019810210210257525257 | nx513j | Nubia | 1920*1080 | AArch64 Processor Rev 1 (aarch64) | Wi-Fi | Unknown | Orange | Unknown | Unknown | Android | 5.1.1 | 8 | | 10391 | 14677915459507539AA11E10150E4B25 | 1.0.2.26961 | Digital Home Android | 20170225165734708_14:3E:BF:FF:94:49_14677915459507539AA11E10150E4B25 | 20170225165803164 | 20170225 | 27999 | 4952511019810210210257525257 | nx513j | Nubia | 1920*1080 | AArch64 Processor Rev 1 (aarch64) | Wi-Fi | Unknown | Orange | Unknown | Unknown | Android | 5.1.1 | 8 | | 10391 | 14677915459507539AA11E10150E4B25 | 1.0.2.26961 | Digital Home Android | 20170225165803167_14:3E:BF:FF:94:49_14677915459507539AA11E10150E4B25 | 20170225165849707 | 20170225 | 44360 | 4952511019810210210257525257 | nx513j | Nubia | 1920*1080 | AArch64 Processor Rev 1 (aarch64) | Wi-Fi | Unknown | Orange | Unknown | Unknown | Android | 5.1.1 | 8 | | 10391 | 14677915459507539AA11E10150E4B25 | 1.0.2.26961 | Digital Home Android | 20170225165849708_14:3E:BF:FF:94:49_14677915459507539AA11E10150E4B25 | 20170225165853061 | 20170225 | 3212 | 4952511019810210210257525257 | nx513j | Nubia | 1920*1080 | AArch64 Processor Rev 1 (aarch64) | Wi-Fi | Unknown | OraNge | Unknown | Unknown | Android | 5.1.1 | 8 | | 10391 | 14677915459507539AA11E10150E4B25 | 1.0.2.26961 | Digital Home Android | 20170225165853065_14:3E:BF:FF:94:49_14677915459507539AA11E10150E4B25 | 20170225165854179 | 20170225 | 982 | 4952511019810210210257525257 | nx513j | Nubia | 1920*1080 | AArch64 Processor Rev 1 (aarch64) | Wi-Fi | Unknown | Orange | Unknown | Unknown | Android | 5.1.1 | 8 | | 10391 | 14677915459507539AA11E10150E4B25 | 1.0.2.26961 | Digital Home Android | 20170225165854180_14:3E:BF:FF:94:49_14677915459507539AA11E10150E4B25 | 20170225165917006 | 20170225 | 22777 | 4952511019810210210257525257 | nx513j | Nubia | 1920*1080 | AArch64 Processor Rev 1 (aarch64) | Wi-Fi | Unknown | Orange | Unknown | Unknown | Android | 5.1.1 | 8 | | 10391 | 14677915459507539AA11E10150E4B25 | 1.0.2.26961 | Digital Home Android | 20170225165917009_14:3E:BF:FF:94:49_14677915459507539AA11E10150E4B25 | 20170225165930321 | 20170225 | 13064 | 4952511019810210210257525257 | nx513j | Nubia | 1920*1080 | AArch64 Processor Rev 1 (aarch64) | Wi-Fi | Unknown | Orange | Unknown | Unknown | Android | 5.1.1 | 8 | | 10391 | 14677915459507539AA11E10150E4B25 | 1.0.2.26961 | Digital Home Android | 20170225165930323_14:3E:BF:FF:94:49_14677915459507539AA11E10150E4B25 | 20170225165935414 | 20170225 | 4938 | 4952511019810210210257525257 | nx513j | Nubia | 1920*1080 | AArch64 Processor Rev 1 (aarch64) | Wi-Fi | Unknown | Orange | Unknown | Unknown | Android | 5.1.1 |
8 | +----------------+-----------------------------------+--------------------------+--------------------+--------- --------------------------------------------------------------+----------------------------+------------------- ---------+-------------------+-------------------------------+-----------------------+------------------------- ----+----------------------------+------------------------------------+-----------------+---------------------- +------------------+------------------+-------------------+-------------+---------------------+---------------- ---+--+
0:jdbc:hive2://mini01:10000> SELECT * from activity limit 10; +-----------------+-----------------------------------+-------------------------------------------------------- ---------------+-----------------------------------------------------------------------------------------+----- ------------------------+-----------------------------+----------------------------+-------------------------+- -+
| Activity.appid | Activity.appkey | activity.session_id | Activity.activityname | activity.local_time_string | activity.local_date_string | activity.activityduration |
Activity.activityindex | +-----------------+-----------------------------------+-------------------------------------------------------- ---------------+-----------------------------------------------------------------------------------------+----- ------------------------+-----------------------------+----------------------------+-------------------------+--+
| 10391 | 14677915459507539AA11E10150E4B25 | 20170225164024813_14:3E:BF:FF:94:49_14677915459507539AA11E10150E4B25 | com.cmri.universalapp.SmartMainActivity | 0 | 0 | 8108 | 1 | | 10391 | 14677915459507539AA11E10150E4B25 | 20170225165722192_14:3E:BF:FF:94:49_14677915459507539AA11E10150E4B25 | com.cmri.universalapp.SmartMainActivity | 0 | 0 | 4559 | 1 | | 10391 | 14677915459507539AA11E10150E4B25 | 20170225165726953_14:3E:BF:FF:94:49_14677915459507539AA11E10150E4B25 | com.cmri.universalapp.setting.SettingActivity | 0 | 0 | 998 | 1 | | 10391 | 14677915459507539AA11E10150E4B25 | 20170225165726953_14:3E:BF:FF:94:49_14677915459507539AA11E10150E4B25 | com.cmri.universalapp.device.hardware.smarthardware.chuseraccount.view.CHLoginActivity | 0 | 0 | 6398 | 2 | | 10391 | 14677915459507539AA11E10150E4B25 | 20170225165734708_14:3E:BF:FF:94:49_14677915459507539AA11E10150E4B25 | com.cmri.universalapp.setting.SettingActivity | 0 | 0 | 1388 | 1 | | 10391 | 14677915459507539AA11E10150E4B25 | 20170225165734708_14:3E:BF:FF:94:49_14677915459507539AA11E10150E4B25 | com.cmri.universalapp.device.hardware.smarthardware.chuseraccount.view.CHLoginActivity | 0 | 0 | 26611 | 2 | | 10391 | 14677915459507539AA11E10150E4B25 | 20170225165803167_14:3E:BF:FF:94:49_14677915459507539AA11E10150E4B25 | com.cmri.universalapp.setting.SettingActivity | 0 | 0 | 377 | 1 | | 10391 | 14677915459507539AA11E10150E4B25 | 20170225165803167_14:3E:BF:FF:94:49_14677915459507539AA11E10150E4B25 | com.cmri.universalapp.SmartMainActivity | 0 | 0 | 590 | 2 | | 10391 | 14677915459507539AA11E10150E4B25 | 20170225165803167_14:3E:BF:FF:94:49_14677915459507539AA11E10150E4B25 | com.cmri.universalapp.SmartMainActivity | 0 | 0 | 43393 | 3 | | 10391 | 14677915459507539AA11E10150E4B25 | 20170225165849708_14:3E:BF:FF:94:49_14677915459507539AA11E10150E4B25 | com.cmri.universalapp.setting.SettingActivity | 0 | 0 | 942 |
1 | +-----------------+-----------------------------------+-------------------------------------------------------- ---------------+-----------------------------------------------------------------------------------------+----- ------------------------+-----------------------------+----------------------------+-------------------------+- -+
0:jdbc:hive2://mini01:10000> SELECT * from event where appid!=10391 limit 10; +--------------+-----------------------------------+----------------------------------------------------+------ --------------------+--------------------------+------------+--------------+------------+------------------+--- ------------------------------------+----------------+--+
| Event.appid | Event.appkey | event.session_id | event.local_time_string | event.local_date_string | Event.tag | Event.label | EVENT.ACC | Event.attribute | event.terminal_id |
event.version | +--------------+-----------------------------------+----------------------------------------------------+------ --------------------+--------------------------+------------+--------------+------------+------------------+--- ------------------------------------+----------------+--+
| 10392 | 1467853866494ceb53c83655097037de | B9db0e62-946d-4f5c-b049-ada6d713d3171490251609284 | 20170323144658286 | 20170323 | Andnews | Recommended for You | 1 | News_hot | b9db0e62-946d-4f5c-b049-ada6d713d317 | 1.1.0 | | 10392