在我执行查询的时候，出现这个问题，别的字段可以查询，time这个字段不行（类型是timestamp）
SQL: SELECT TIME,COUNT(*) FROM WX_CLICKS GROUP BY TIME
User: ADMIN
Success: false
Duration: 0.009
Project: kylin_qrcode
Realization Names: []
Cuboid Ids: []
Total scan count: 0
Total scan bytes: 0
Result row count: 0
Accept Partial: true
Is Partial Result: false
Hit Exception Cache: false
Storage cache used: false
Is Query Push-Down: false
Is Prepare: false
Trace URL: null
Message: Encountered "TIME ," at line 1, column 8. Was expecting one of:
"UNION" ... "INTERSECT" ... "EXCEPT" ... "MINUS" ... "ORDER"
... "LIMIT" ... "OFFSET" ... "FETCH" ... "STREAM" ...
"DISTINCT" ... "ALL" ... "*" ... "+" ... "-" ... "NOT" ...
"EXISTS" ... <UNSIGNED_INTEGER_LITERAL> ...
<DECIMAL_NUMERIC_LITERAL> ... <APPROX_NUMERIC_LITERAL> ...
<BINARY_STRING_LITERAL> ... <PREFIXED_STRING_LITERAL> ...
<QUOTED_STRING> ... <UNICODE_STRING_LITERAL> ... "TRUE" ... "FALSE"
... "UNKNOWN" ... "NULL" ... <LBRACE_D> ... <LBRACE_T> ...
<LBRACE_TS> ... "DATE" ... "TIME" <QUOTED_STRING> ... "TIMESTAMP"
... "INTERVAL" ... "?" ... "CAST" ... "EXTRACT" ...
"POSITION" ... "CONVERT" ... "TRANSLATE" ... "OVERLAY" ...
"FLOOR" ... "CEIL" ... "CEILING" ... "SUBSTRING" ... "TRIM" ...
"CLASSIFIER" ... "MATCH_NUMBER" ... "RUNNING" ... "PREV" ...
"NEXT" ... <LBRACE_FN> ... "MULTISET" ... "ARRAY" ... "PERIOD"
... "SPECIFIC" ... <IDENTIFIER> ... <QUOTED_IDENTIFIER> ...
<BACK_QUOTED_IDENTIFIER> ... <BRACKET_QUOTED_IDENTIFIER> ...
<UNICODE_QUOTED_IDENTIFIER> ... "ABS" ... "AVG" ... "CARDINALITY"
... "CHAR_LENGTH" ... "CHARACTER_LENGTH" ... "COALESCE" ...
"COLLECT" ... "COVAR_POP" ... "COVAR_SAMP" ... "CUME_DIST" ...
"COUNT" ... "CURRENT_DATE" ... "CURRENT_TIME" ...
"CURRENT_TIMESTAMP" ... "DENSE_RANK" ... "ELEMENT" ... "EXP" ...
"FIRST_VALUE" ... "FUSION" ... "GROUPING" ... "HOUR" ... "LAG"
... "LEAD" ... "LAST_VALUE" ... "LN" ... "LOCALTIME" ...
"LOCALTIMESTAMP" ... "LOWER" ... "MAX" ... "MIN" ... "MINUTE"
... "MOD" ... "MONTH" ... "NTILE" ... "NULLIF" ...
"OCTET_LENGTH" ... "PERCENT_RANK" ... "POWER" ... "RANK" ...
"REGR_SXX" ... "REGR_SYY" ... "ROW_NUMBER" ... "SECOND" ...
"SQRT" ... "STDDEV_POP" ... "STDDEV_SAMP" ... "SUM" ... "UPPER"
... "TRUNCATE" ... "USER" ... "VAR_POP" ... "VAR_SAMP" ...
"YEAR" ... "CURRENT_CATALOG" ... "CURRENT_DEFAULT_TRANSFORM_GROUP" ...
"CURRENT_PATH" ... "CURRENT_ROLE" ... "CURRENT_SCHEMA" ...
"CURRENT_USER" ... "SESSION_USER" ... "SYSTEM_USER" ... "NEW" ...
"CASE" ... "CURRENT" ... "CURSOR" ... "ROW" ... "(" ...
==========================[QUERY]===============================
2019-12-02 17:18:47,293 ERROR [http-bio-7070-exec-8]
controller.BasicController:63 :
org.apache.kylin.rest.exception.InternalErrorException: Encountered "TIME ," at
line 1, column 8. Was expecting one of: "UNION" ... "INTERSECT" ...
"EXCEPT" ... "MINUS" ... "ORDER" ... "LIMIT" ... "OFFSET" ...
"FETCH" ... "STREAM" ... "DISTINCT" ... "ALL" ... "*" ...
"+" ... "-" ... "NOT" ... "EXISTS" ...
<UNSIGNED_INTEGER_LITERAL> ... <DECIMAL_NUMERIC_LITERAL> ...
<APPROX_NUMERIC_LITERAL> ... <BINARY_STRING_LITERAL> ...
<PREFIXED_STRING_LITERAL> ... <QUOTED_STRING> ...
<UNICODE_STRING_LITERAL> ... "TRUE" ... "FALSE" ... "UNKNOWN" ...
"NULL" ... <LBRACE_D> ... <LBRACE_T> ... <LBRACE_TS> ...
"DATE" ... "TIME" <QUOTED_STRING> ... "TIMESTAMP" ... "INTERVAL"
... "?" ... "CAST" ... "EXTRACT" ... "POSITION" ...
"CONVERT" ... "TRANSLATE" ... "OVERLAY" ... "FLOOR" ... "CEIL"
... "CEILING" ... "SUBSTRING" ... "TRIM" ... "CLASSIFIER" ...
"MATCH_NUMBER" ... "RUNNING" ... "PREV" ... "NEXT" ...
<LBRACE_FN> ... "MULTISET" ... "ARRAY" ... "PERIOD" ...
"SPECIFIC" ... <IDENTIFIER> ... <QUOTED_IDENTIFIER> ...
<BACK_QUOTED_IDENTIFIER> ... <BRACKET_QUOTED_IDENTIFIER> ...
<UNICODE_QUOTED_IDENTIFIER> ... "ABS" ... "AVG" ... "CARDINALITY"
... "CHAR_LENGTH" ... "CHARACTER_LENGTH" ... "COALESCE" ...
"COLLECT" ... "COVAR_POP" ... "COVAR_SAMP" ... "CUME_DIST" ...
"COUNT" ... "CURRENT_DATE" ... "CURRENT_TIME" ...
"CURRENT_TIMESTAMP" ... "DENSE_RANK" ... "ELEMENT" ... "EXP" ...
"FIRST_VALUE" ... "FUSION" ... "GROUPING" ... "HOUR" ... "LAG"
... "LEAD" ... "LAST_VALUE" ... "LN" ... "LOCALTIME" ...
"LOCALTIMESTAMP" ... "LOWER" ... "MAX" ... "MIN" ... "MINUTE"
... "MOD" ... "MONTH" ... "NTILE" ... "NULLIF" ...
"OCTET_LENGTH" ... "PERCENT_RANK" ... "POWER" ... "RANK" ...
"REGR_SXX" ... "REGR_SYY" ... "ROW_NUMBER" ... "SECOND" ...
"SQRT" ... "STDDEV_POP" ... "STDDEV_SAMP" ... "SUM" ... "UPPER"
... "TRUNCATE" ... "USER" ... "VAR_POP" ... "VAR_SAMP" ...
"YEAR" ... "CURRENT_CATALOG" ... "CURRENT_DEFAULT_TRANSFORM_GROUP" ...
"CURRENT_PATH" ... "CURRENT_ROLE" ... "CURRENT_SCHEMA" ...
"CURRENT_USER" ... "SESSION_USER" ... "SYSTEM_USER" ... "NEW" ...
"CASE" ... "CURRENT" ... "CURSOR" ... "ROW" ... "(" ...
at
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:449)
at
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:375)
at
org.apache.kylin.rest.controller.QueryController.query(QueryController.java:93)
at sun.reflect.GeneratedMethodAccessor243.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
at
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
at
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
at
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
at
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
at
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
at
org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
at
org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
at
org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
at
org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
at
org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:215)
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
at
org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
at
org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
at
org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
at
org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
at
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
at
org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
at
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
at
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at
com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:209)
at
com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1137)
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
发件人：ShaoFeng Shi <[email protected]>
发送时间：2019-12-02 17:09
主题：Re: kylin
收件人："user"<[email protected]>
抄送：
Hi xiaodong,
In the FAQ page (https://kylin.apache.org/docs/gettingstarted/faq.html), there
is a similar question:
"The query result is not exactly matched with that in Hive, what’s the possible
reason?"
You can search and check that if not. Hope it can help.
Best regards,
Shaofeng Shi 史少锋
Apache Kylin PMC
Email: [email protected]
Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html
Join Kylin user mail group: [email protected]
Join Kylin dev mail group: [email protected]
肖培栋 <[email protected]> 于2019年12月2日周一 下午4:42写道：
kylin的cube构建之后，生成的数据条数和我原表hive中的数据条殊不一致，怎么查找原因？？？
