You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@carbondata.apache.org by "zhangzhuo (JIRA)" <ji...@apache.org> on 2018/07/09 05:27:00 UTC

[jira] [Commented] (CARBONDATA-2707) count(*) is not working

    [ https://issues.apache.org/jira/browse/CARBONDATA-2707?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16536546#comment-16536546 ] 

zhangzhuo commented on CARBONDATA-2707:
---------------------------------------

but when i create another table,such as:

1.count(*) from table A ,  table not found

2.create table B 

3.count(*) from table A, success!

 

> count(*) is not working 
> ------------------------
>
>                 Key: CARBONDATA-2707
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-2707
>             Project: CarbonData
>          Issue Type: Bug
>          Components: build, sql
>    Affects Versions: 1.3.1
>            Reporter: zhangzhuo
>            Priority: Critical
>
> I use thrift server to query the carbontable.
> But when i use "select count(*) from table" ,i got an error like this:
> Error: org.apache.spark.sql.AnalysisException: Table or view not found: carbon_user_0701; line 1 pos 21 (state=,code=0)
> And then , i use the explain command to show how the physical plan is :
> | == Physical Plan ==
> CarbonCountStar [count(1)#4563L], org.apache.carbondata.core.metadata.schema.table.CarbonTable@7296491f, org.apache.spark.sql.CarbonSession@5e96ea34, true  |
> It looks like when running count(*) command , it will find cache in current session ,but not in the session which the table be created.
> So,what can i do to make the session same or what can i do to make the count(*) command work?



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)