Not able to set reflection

1

i am running dremio on kubernate and connected SQL server as data-source after that when i am setting reflection after that i hangs saying reflection in progress

image
image.jpg1920×1080 339 KB

2

Hi @Vikash_Singh

Would you know,

  1. How big the SQL server table is?
  2. How many executors you have?
  3. What is the # of CPU’s on each of these executors?

Can you please send us the profile? Below tutorial talks about how to download the profile

How To Share A Query Profile

Thanks
@balaji.ramaswamy

3
  1. How big the SQL server table is? -> its of 10k records
  2. How many executors you have? --> only 1
  3. What is the # of CPU’s on each of these executors? I have assb61bd4a7-b777-4466-a2fa-ed8a7784c4db.zip (6.5 KB)
    igned 8GB RAM,1 CPU
4

The profile you attached is of a query, do you have one for the reflection creation?

Additionally, I wouldn’t necessarily say it’s “hanging”. It seems like it’s still processing and may be taking awhile. It may be worth noting your executor node is really small and undersized, it is below our recommended minimum requirements - https://docs.dremio.com/deployment/system-requirements.html#server-or-instance