0

MV can not load value

I have created MV like this:

SELECT

EXADATA_URIM.TT_URIM.URIM_DEN_NO,

EXADATA_URIM.TT_URIM.URIM_HKK_DATE,

EXADATA_URIM.TT_URIM.URIM_HKK_TIME

FROM

EXADATA_URIM.TT_URIM

WHERE

EXADATA_URIM.TT_URIM.URIM_DEN_NO = '0010233456789'

but when I load it, it return  0 record. I make sure that URIM_DEN_NO = '0010233456789' exists in EXADATA_URIM.TT_URIM by test it in Explore Data. Have someone met this case and can explain it to me ? thanks you.

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Nopu Nguyen I'd first verify the data types are consistent for URIM_DEN_NO between source and MV tables. Next check if there are any leading/trailing spaces and lastly try removing your predicate just to confirm the data loads correctly. If it is a large table, you can limit the rows by using LIMIT keyword after your Spark SQL query.

    Like
Like Follow
  • 2 mths agoLast active
  • 1Replies
  • 20Views
  • 2 Following

Product Announcement

Incorta 4.9 is now Generally Available (GA)!!!