select count(*) not working

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

select count(*) not working

zzhang9
hi,dev

i got some issue when using carbondata.

when i use "select count(*) from carbontable" i got such error:

Error: org.apache.spark.sql.catalyst.analysis.NoSuchTableException: Table or view 'carbon_user' not found in database 'default'; (state=,code=0)


And then i explain this sql,

| == Physical Plan ==

CarbonCountStar [count(1)#2923L], org.apache.carbondata.core.metadata.schema.table.CarbonTable@42a660af, org.apache.spark.sql.CarbonSession@2898fa97, true  |


It seems like when do count(*),carbondata will read the carbonsession cache,but the session id is always change,only in the session  in which the table firste by created ,then the count(*) works.


So,i want to know is there any way to get the cache ?

本邮件及其附件含有小红书公司的保密信息,仅限于发送给以上收件人或群组。禁止任何其他人以任何形式使用(包括但不限于全部或部分地泄露、复制、或散发)本邮件中的信息。如果您错收了本邮件,请您立即电话或邮件通知发件人并删除本邮件!
This communication may contain privileged or other confidential information of Red. If you have received it in error, please advise the sender by reply e-mail and immediately delete the message and any attachments without copying or disclosing the contents. Thank you.
Reply | Threaded
Open this post in threaded view
|

Re: select count(*) not working

xuchuanyin
Will `show tables` show the table?

> On Jul 6, 2018, at 17:08, 张倬 <[hidden email]> wrote:
>
> carbondata

Reply | Threaded
Open this post in threaded view
|

Re: select count(*) not working

zzhang9
yeah.
"show tables" can show the table which i want to do count operation



--
Sent from: http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/