MV can not load value
I have created MV like this:
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.
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.