How to use NQ logs to check data in DB

最新推荐文章于 2024-09-06 13:36:37 发布

Seaee

最新推荐文章于 2024-09-06 13:36:37 发布

阅读量750

点赞数

CC 4.0 BY-SA版权

分类专栏： BI 文章标签： HCM DATA Analysis SATA Physical SQL Logical

本文链接：https://blog.youkuaiyun.com/Seaee/article/details/50206247

BI 专栏收录该内容

10 篇文章

订阅专栏

本文介绍如何利用NQ日志文件来查找与逻辑查询相关的物理查询。通过Ctrl+F搜索特定的逻辑请求哈希（例如：3911c487），可以找到对应的物理查询，这些查询以[WITH]开头并以[orderby*******<=65001]结束。NQ日志路径为：http://url:10217/getlogs/OracleBIServerComponent/coreapplication_obis1/nqquery.log。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

How to use NQ logs.

Using NQ logs we can find physical queries which are related to logical queries for test cases. This is a pair patten. one physical query ------ one logical query.

Ctrl+F find your logical query in this log with keyword. You can find a logical request hash, ie: 3911c487

Search this hash code in this log, you can find the physical query which is head with [WITH] and end with [order by ******* <= 65001].

The Path of NQ logs: (http://url:10217/getlogs/OracleBIServerComponent/coreapplication_obis1/nqquery.log)

Please check the latest one.