error-: report too large

ahana ahana 1

i am trying to load the data from quick base to data bricks it says report too large

below is the code-:

%python

df = quickbasePull('b5zj8k_pbz5_0_cd5h4wbbpzyytd77n4nvp95b4u','bq2ma8jm7',24, )

Then i tried another code to pull report from quick base

Below is the code-:

%python

import pyqb from pyspark.sql import * import pandas as pd qbc = pyqb.Client(url='https://tvcm.quickbase.com/',user_token='b5zj8k_pbz5_0_cd5h4wbbpzyytd77n4nvp95b4u',database='bq2ma8jm7') result = qbc.doquery(qid=24,database='bq2ma8jm7',fields=["1","2","3","4","5","6","7","8"]) samp = result['record'] df = pd.DataFrame(samp) df = spark.createDataFrame(df) df.createOrReplaceTempView('otl')

But it is giving me wrong result

plz help to resolve...............?

HimanshuSinha-msft 19,381 Reputation points Microsoft Employee

2022-08-16T00:40:05.847+00:00

Hello @ahana ahana ,
Thanks for the question and using MS Q&A platform.

looking the code which you shared , i see that you are creating the view with the name "otl:

df.createOrReplaceTempView('otl')

But you are quering the view OTLS ( the screenshot) , Are you sure you are quering the right view ?

We will wait to hear from you . .
Thanks
Himanshu
ahana ahana 1 Reputation point

2022-08-16T05:25:39.543+00:00

yes i am creating the view OTL so from that view i will create the table with require field.
In select query i was checking what result am i getting from above python query

But i need the sample result like below table with all the column
ahana ahana 1 Reputation point

2022-08-16T06:39:14.507+00:00

@ Himanshu That is otl only thnx i update that in question
HimanshuSinha-msft 19,381 Reputation points Microsoft Employee

2022-09-08T19:14:20.983+00:00

Hello @ahana ahana ,
Apologies for the delay in reply from our side .Did you got a resolution for this ?
Thanks
Himanshu