答复: got exception when start kylin

2019-02-24 Thread Na Zhai 
Hi, chenyang



Have you modified any configuration of Tomcat?



发送自 Windows 10 版邮件应用




发件人: chenyang 
发送时间: Friday, February 22, 2019 4:30:20 PM
收件人: dev@kylin.apache.org
主题: got exception when start kylin

may someone help me to solve this WARN：
｀｀｀
org.apache.catalina.LifecycleException: Failed to initialize component
[Connector[org.apache.coyote.http11.Http11Protocol-7443]]
at
org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:112)
at
org.apache.catalina.core.StandardService.initInternal(StandardService.java:552)
at
org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:107)
at
org.apache.catalina.core.StandardServer.initInternal(StandardServer.java:875)
at
org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:107)
at org.apache.catalina.startup.Catalina.load(Catalina.java:632)
at org.apache.catalina.startup.Catalina.start(Catalina.java:669)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:353)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:493)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hadoop.util.RunJar.run(RunJar.java:313)
at org.apache.hadoop.util.RunJar.main(RunJar.java:227)
Caused by: org.apache.catalina.LifecycleException: Protocol handler
initialization failed
at
org.apache.catalina.connector.Connector.initInternal(Connector.java:995)
at
org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:107)
... 18 more
Caused by: java.lang.IllegalArgumentException:
/home/deployer/apache-kylin-2.5.2-bin-cdh60/tomcat/conf/.keystore (No such
file or directory)
at
org.apache.tomcat.util.net.AbstractJsseEndpoint.createSSLContext(AbstractJsseEndpoint.java:115)
at
org.apache.tomcat.util.net.AbstractJsseEndpoint.initialiseSsl(AbstractJsseEndpoint.java:86)
at org.apache.tomcat.util.net.NioEndpoint.bind(NioEndpoint.java:244)
at
org.apache.tomcat.util.net.AbstractEndpoint.init(AbstractEndpoint.java:1087)
at
org.apache.tomcat.util.net.AbstractJsseEndpoint.init(AbstractJsseEndpoint.java:265)
at
org.apache.coyote.AbstractProtocol.init(AbstractProtocol.java:581)
at
org.apache.coyote.http11.AbstractHttp11Protocol.init(AbstractHttp11Protocol.java:68)
at
org.apache.catalina.connector.Connector.initInternal(Connector.java:993)
... 19 more
Caused by: java.io.FileNotFoundException:
/home/deployer/apache-kylin-2.5.2-bin-cdh60/tomcat/conf/.keystore (No such
file or directory)
at java.io.FileInputStream.open0(Native Method)
at java.io.FileInputStream.open(FileInputStream.java:195)
at java.io.FileInputStream.(FileInputStream.java:138)
at java.io.FileInputStream.(FileInputStream.java:93)
at
sun.net.www.protocol.file.FileURLConnection.connect(FileURLConnection.java:90)
at
sun.net.www.protocol.file.FileURLConnection.getInputStream(FileURLConnection.java:188)
at
org.apache.tomcat.util.file.ConfigFileLoader.getInputStream(ConfigFileLoader.java:89)
at
org.apache.tomcat.util.net.SSLUtilBase.getStore(SSLUtilBase.java:140)
at
org.apache.tomcat.util.net.SSLHostConfigCertificate.getCertificateKeystore(SSLHostConfigCertificate.java:204)
at
org.apache.tomcat.util.net.jsse.JSSEUtil.getKeyManagers(JSSEUtil.java:184)
at
org.apache.tomcat.util.net.AbstractJsseEndpoint.createSSLContext(AbstractJsseEndpoint.java:113)
... 26 more
｀｀｀

--
Sent from: http://apache-kylin.74782.x6.nabble.com/

Re: Hbase table is always empty when build with spark

2019-02-24 Thread ShaoFeng Shi 
Hello Alex,

Interesting; We didn't observe such an issue. Can you confirm your hive
table has the data, instead of an input error? Does the problem get solved
after setting "mapreduce.job.outputformat.class"?

Thanks for the feedback!

Best regards,

Shaofeng Shi 史少锋
Apache Kylin PMC
Work email: shaofeng@kyligence.io
Kyligence Inc: https://kyligence.io/

Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html
Join Kylin user mail group: user-subscr...@kylin.apache.org
Join Kylin dev mail group: dev-subscr...@kylin.apache.org




mailpig  于2019年2月20日周三 上午11:18写道：

> In kylin-2.5.2, the result hbase table is always table is always empty
> when I
> build cube with spark.
> I found that the step "Load HFile to HBase Table" has some warn log:
> /2019-01-27 00:49:30,067 WARN [Scheduler 448149092 Job
> 89a25959-e12d-7a5e-0ecb-80c978533eab-6419]
> mapreduce.LoadIncrementalHFiles:204 : Skipping non-directory
>
> hdfs://test/kylin/kylin_metadata/kylin-89a25959-e12d-7a5e-0ecb-80c978533eab/test_UUID_spark/hfile/_SUCCESS
> 2019-01-27 00:49:30,068 WARN [Scheduler 448149092 Job
> 89a25959-e12d-7a5e-0ecb-80c978533eab-6419]
> mapreduce.LoadIncrementalHFiles:204 : Skipping non-directory
>
> hdfs://test/kylin/kylin_metadata/kylin-89a25959-e12d-7a5e-0ecb-80c978533eab/test_UUID_spark/hfile/part-r-0
> 2019-01-27 00:49:30,068 WARN [Scheduler 448149092 Job
> 89a25959-e12d-7a5e-0ecb-80c978533eab-6419]
> mapreduce.LoadIncrementalHFiles:204 : Skipping non-directory
>
> hdfs://test/kylin/kylin_metadata/kylin-89a25959-e12d-7a5e-0ecb-80c978533eab/test_UUID_spark/hfile/part-r-1/
>
> After read the source code, I found the step "Convert Cuboid Data to HFile"
> with spark has bug. The above step's outputdir should has subdirectory with
> column family. Indeed, SparkCubeHFile must set
> mapreduce.job.outputformat.class with HFileOutputFormat2.class.
>
> Please check if I am correct！
>
> --
> Sent from: http://apache-kylin.74782.x6.nabble.com/
>

Re: can not open kylin web ui

2019-02-24 Thread ShaoFeng Shi 
Remember to add the "/kylin" context on the URL, sometimes people may
forget: http://hostname:7070/kylin

Best regards,

Shaofeng Shi 史少锋
Apache Kylin PMC
Work email: shaofeng@kyligence.io
Kyligence Inc: https://kyligence.io/

Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html
Join Kylin user mail group: user-subscr...@kylin.apache.org
Join Kylin dev mail group: dev-subscr...@kylin.apache.org




JiaTao Tao  于2019年2月23日周六 下午12:09写道：

> Hi
>
> You can check files in "${KYLIN_HOME)/logs" and see if there's something
> unexpected occurs.
>
> --
>
>
> Regards!
>
> Aron Tao
>
> hetadesai56  于2019年2月22日周五 下午2:34写道：
>
> > Hi,
> >
> > I am working on HDP 2.6.5 on virtual box. I have installed
> > apache-kylin-2.6.0-bin. kylin started successfully. But Web UI is not
> > working. I did port forwarding in virtual box for kylin default port
> 7070.
> >
> > How can i resolve this ?
> >
> > Thank you,
> > Heta
> >
> > --
> > Sent from: http://apache-kylin.74782.x6.nabble.com/
> >
>

Re: got exception when start kylin

2019-02-24 Thread ShaoFeng Shi 
Please try to check more logs, both in /logs and tomcat/logs. I remember
some users also encountered the "/tomcat/conf/.keystore (No such
file or directory)" error before, but this was not the root cause.

Best regards,

Shaofeng Shi 史少锋
Apache Kylin PMC
Work email: shaofeng@kyligence.io
Kyligence Inc: https://kyligence.io/

Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html
Join Kylin user mail group: user-subscr...@kylin.apache.org
Join Kylin dev mail group: dev-subscr...@kylin.apache.org




Na Zhai  于2019年2月24日周日 下午8:15写道：

> Hi, chenyang
>
>
>
> Have you modified any configuration of Tomcat?
>
>
>
> 发送自 Windows 10 版邮件应用
>
>
>
> 
> 发件人: chenyang 
> 发送时间: Friday, February 22, 2019 4:30:20 PM
> 收件人: dev@kylin.apache.org
> 主题: got exception when start kylin
>
> may someone help me to solve this WARN：
> ｀｀｀
> org.apache.catalina.LifecycleException: Failed to initialize component
> [Connector[org.apache.coyote.http11.Http11Protocol-7443]]
> at
> org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:112)
> at
>
> org.apache.catalina.core.StandardService.initInternal(StandardService.java:552)
> at
> org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:107)
> at
>
> org.apache.catalina.core.StandardServer.initInternal(StandardServer.java:875)
> at
> org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:107)
> at org.apache.catalina.startup.Catalina.load(Catalina.java:632)
> at org.apache.catalina.startup.Catalina.start(Catalina.java:669)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
>
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:353)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:493)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
>
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at org.apache.hadoop.util.RunJar.run(RunJar.java:313)
> at org.apache.hadoop.util.RunJar.main(RunJar.java:227)
> Caused by: org.apache.catalina.LifecycleException: Protocol handler
> initialization failed
> at
> org.apache.catalina.connector.Connector.initInternal(Connector.java:995)
> at
> org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:107)
> ... 18 more
> Caused by: java.lang.IllegalArgumentException:
> /home/deployer/apache-kylin-2.5.2-bin-cdh60/tomcat/conf/.keystore (No such
> file or directory)
> at
> org.apache.tomcat.util.net
> .AbstractJsseEndpoint.createSSLContext(AbstractJsseEndpoint.java:115)
> at
> org.apache.tomcat.util.net
> .AbstractJsseEndpoint.initialiseSsl(AbstractJsseEndpoint.java:86)
> at org.apache.tomcat.util.net
> .NioEndpoint.bind(NioEndpoint.java:244)
> at
> org.apache.tomcat.util.net
> .AbstractEndpoint.init(AbstractEndpoint.java:1087)
> at
> org.apache.tomcat.util.net
> .AbstractJsseEndpoint.init(AbstractJsseEndpoint.java:265)
> at
> org.apache.coyote.AbstractProtocol.init(AbstractProtocol.java:581)
> at
>
> org.apache.coyote.http11.AbstractHttp11Protocol.init(AbstractHttp11Protocol.java:68)
> at
> org.apache.catalina.connector.Connector.initInternal(Connector.java:993)
> ... 19 more
> Caused by: java.io.FileNotFoundException:
> /home/deployer/apache-kylin-2.5.2-bin-cdh60/tomcat/conf/.keystore (No such
> file or directory)
> at java.io.FileInputStream.open0(Native Method)
> at java.io.FileInputStream.open(FileInputStream.java:195)
> at java.io.FileInputStream.(FileInputStream.java:138)
> at java.io.FileInputStream.(FileInputStream.java:93)
> at
>
> sun.net.www.protocol.file.FileURLConnection.connect(FileURLConnection.java:90)
> at
>
> sun.net.www.protocol.file.FileURLConnection.getInputStream(FileURLConnection.java:188)
> at
>
> org.apache.tomcat.util.file.ConfigFileLoader.getInputStream(ConfigFileLoader.java:89)
> at
> org.apache.tomcat.util.net.SSLUtilBase.getStore(SSLUtilBase.java:140)
> at
> org.apache.tomcat.util.net
> .SSLHostConfigCertificate.getCertificateKeystore(SSLHostConfigCertificate.java:204)
> at
> org.apache.tomcat.util.net.jsse.JSSEUtil.getKeyManagers(JSSEUtil.java:184)
> at
> org.apache.tomcat.util.net
> .AbstractJsseEndpoint.createSSLContext(AbstractJsseEndpoint.java:113)
> ... 26 more
> ｀｀｀
>
> --
> Sent from: http://apa

Re: 答复: got exception when start kylin

2019-02-24 Thread chenyang 
no, I don't. 
I just follow the installation guid
(http://kylin.apache.org/cn/docs/install/index.html)

BTW，we use CDH6.0.1

--
Sent from: http://apache-kylin.74782.x6.nabble.com/

Re: got exception when start kylin

2019-02-24 Thread chenyang 
hi Shaofeng Shi,

I find some warning at tomcat/logs/catalina.log

```
22-Feb-2019 15:43:09.140 WARNING [localhost-startStop-1]
org.apache.jasper.runtime.TldScanner.scanJar jsp.warn.nojar
 java.io.FileNotFoundException:
/data/opt/cloudera/parcels/CDH-6.0.1-1.cdh6.0.1.p0.590678/lib/hbase/*.jar
(No such file or directory)
at java.util.zip.ZipFile.open(Native Method)
at java.util.zip.ZipFile.(ZipFile.java:219)
at java.util.zip.ZipFile.(ZipFile.java:149)
at java.util.jar.JarFile.(JarFile.java:166)
at java.util.jar.JarFile.(JarFile.java:103)
at sun.net.www.protocol.jar.URLJarFile.(URLJarFile.java:93)
at
sun.net.www.protocol.jar.URLJarFile.getJarFile(URLJarFile.java:69)
at
sun.net.www.protocol.jar.JarFileFactory.get(JarFileFactory.java:99)
at
sun.net.www.protocol.jar.JarURLConnection.connect(JarURLConnection.java:122)
at
sun.net.www.protocol.jar.JarURLConnection.getJarFile(JarURLConnection.java:89)
at org.apache.jasper.runtime.TldScanner.scanJar(TldScanner.java:442)
at
org.apache.jasper.runtime.TldScanner.scanJars(TldScanner.java:694)
at
org.apache.jasper.runtime.TldScanner.scanTlds(TldScanner.java:350)
at
org.apache.jasper.runtime.TldScanner.onStartup(TldScanner.java:239)
at
org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5245)
at
org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
at
org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:985)
at
org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
```

I think this should be my HBASE_CLASSPATH.  So I should change '*' to
explicit name of the jars?

--
Sent from: http://apache-kylin.74782.x6.nabble.com/

Re: got exception when start kylin

2019-02-24 Thread chenyang 
---update-
I correct the HBASE_CLASSPATH =
xx/hbase-server-xxx.jar:x/hbase-common-xxx.jar ,and restart kylin.
The waining in tomcat/logs/catalina.log has gone . 
But still get the previous waring in logs/kylin.log  

--
Sent from: http://apache-kylin.74782.x6.nabble.com/

Re: I wonder about the qualifier assignment within an column family for measures

2019-02-24 Thread ShaoFeng Shi 
Hi Zhang Yu,

Kylin's metadata structure allows dividing the measures to one or multiple
CF/columns. To be simple, the web GUI only asks the user to select CF, and
then combine all the measures in a CF into one column. You can customize
the policy to further divides the measures into different columns if you
think that is better. Please share us with your findings, if it does
benefit the performance.

Thank you!

Best regards,

Shaofeng Shi 史少锋
Apache Kylin PMC
Work email: shaofeng@kyligence.io
Kyligence Inc: https://kyligence.io/

Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html
Join Kylin user mail group: user-subscr...@kylin.apache.org
Join Kylin dev mail group: dev-subscr...@kylin.apache.org




yuzhang  于2019年2月21日周四 下午8:19写道：

>   Hi, dear team, when I read the source code about create HTable and
> CubeDescCreator, I found there is only one column("M") per column
> family(F1, F2, F3). And the column "M" contain all measures which are
> assigned to this column family.  Then, HBaseReadonlyStore will load all
> this column(or Cell) data into buffer in region server, and then only
> return the selected measure to query server. I wonder why don't kyiln
> assign an column qualifer(like M1, M2) per measures?
>
> and if my understanding of these codes is incorrect, could you let me
> know, Please.
> Hope for any of yours reply.
>
> | |
> shifengdefannao
> |
> |
> Email:shifengdefan...@163.com
> |
>
> Signature is customized by Netease Mail Master

[jira] [Created] (KYLIN-3827) kylin 某一字段必须使用trim才可以查出来

2019-02-24 Thread litewood (JIRA) 
litewood created KYLIN-3827:
---

 Summary: kylin 某一字段必须使用trim才可以查出来
 Key: KYLIN-3827
 URL: https://issues.apache.org/jira/browse/KYLIN-3827
 Project: Kylin
  Issue Type: Bug
Affects Versions: v2.5.1
Reporter: litewood


SELECT pt ,pageid from st.ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1 where pt = 
'20190114' and pageid='用户标签文档'  GROUP BY pt,pageid;

当前sql 使用hive查询可以查出来结果。

但是使用kylin接口查询，除去一个近视去重选用全局字段的cube能查询出来，其他cube 必须trim(pageid) 或者使用like 
关键字才能查出来。下面帖出三个cube信息。

 

{color:#FF}可以查出来的cube info （近视去重）{color}
{
  "uuid": "ad8cbc65-dd6c-8c12-7d18-2f625cedf7ea",
  "last_modified": 1550719049143,
  "version": "2.5.1.20500",
  "name": "c_pageview",
  "is_draft": false,
  "model_name": "m_bury_point_analysis",
  "description": "c_pageview",
  "null_string": null,
  "dimensions": [
\{
  "name": "APPTYPE",
  "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1",
  "column": "APPTYPE",
  "derived": null
},
\{
  "name": "PLATFORM",
  "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1",
  "column": "PLATFORM",
  "derived": null
},
\{
  "name": "UTM_SOURCE",
  "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1",
  "column": "UTM_SOURCE",
  "derived": null
},
\{
  "name": "ADCODE",
  "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1",
  "column": "ADCODE",
  "derived": null
},
\{
  "name": "ADDITIONTYPE",
  "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1",
  "column": "ADDITIONTYPE",
  "derived": null
},
\{
  "name": "ADDITIONVALUE",
  "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1",
  "column": "ADDITIONVALUE",
  "derived": null
},
\{
  "name": "APPVERSION",
  "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1",
  "column": "APPVERSION",
  "derived": null
},
\{
  "name": "CATEGORYID",
  "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1",
  "column": "CATEGORYID",
  "derived": null
},
\{
  "name": "CITYCODE",
  "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1",
  "column": "CITYCODE",
  "derived": null
},
\{
  "name": "FLAGVALUE",
  "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1",
  "column": "FLAGVALUE",
  "derived": null
},
\{
  "name": "PAGEID",
  "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1",
  "column": "PAGEID",
  "derived": null
},
\{
  "name": "H_DATE",
  "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1",
  "column": "H_DATE",
  "derived": null
},
\{
  "name": "PT",
  "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1",
  "column": "PT",
  "derived": null
},
\{
  "name": "WEEKYTH_CNT_CN",
  "table": "DIM_PUB_DATE",
  "column": null,
  "derived": [
"WEEKYTH_CNT_CN"
  ]
},
\{
  "name": "WEEKYTH_START_DATA_CN",
  "table": "DIM_PUB_DATE",
  "column": null,
  "derived": [
"WEEKYTH_START_DATA_CN"
  ]
},
\{
  "name": "WEEKYTH_END_DATA_CN",
  "table": "DIM_PUB_DATE",
  "column": null,
  "derived": [
"WEEKYTH_END_DATA_CN"
  ]
}
  ],
  "measures": [
\{
  "name": "PV",
  "function": {
"expression": "COUNT",
"parameter": {
  "type": "constant",
  "value": "1"
},
"returntype": "bigint"
  }
},
\{
  "name": "UV",
  "function": {
"expression": "COUNT_DISTINCT",
"parameter": {
  "type": "column",
  "value": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.USERGUID"
},
"returntype": "hllc(16)"
  }
},
\{
  "name": "DUV",
  "function": {
"expression": "COUNT_DISTINCT",
"parameter": {
  "type": "column",
  "value": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.SSID"
},
"returntype": "hllc(16)"
  }
}
  ],
  "dictionaries": [],
  "rowkey": \{
"rowkey_columns": [
  {
"column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.PT",
"encoding": "dict",
"encoding_version": 1,
"isShardBy": false
  },
  \{
"column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.H_DATE",
"encoding": "dict",
"encoding_version": 1,
"isShardBy": false
  },
  \{
"column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.PAGEID",
"encoding": "dict",
"encoding_version": 1,
"isShardBy": false
  },
  \{
"column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.PLATFORM",
"encoding": "dict",
"encoding_version": 1,
"isShardBy": false
  },
  \{
"column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.CATEGORYID",
"encoding": "dict",
"encoding_version": 1,
"isShardBy": false
  },
  \{
"column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.APPVERSION",
"enc