Desktop productivity for business analysts and programmers

While writing a permanent dataset to Impala

Reply
Occasional Contributor
Posts: 19

While writing a permanent dataset to Impala

 

 

Did anyone experience the issue I am facing? 

 

I am writing an output dataset to Impala, query completed and I am able to open the dataset in SAS but under Task window in EG it says it is still running……………….

 

A screenshot of SAS/EG is attached. 

 

Due to this error, I can’t see the log, because there is no log created yet. We checked on Impala cluster and query is completed successfully. It seems like either SAS/EG is hanging or it is still trying to fetch the databack to SAS.

 

Any suggestion how to address this issue?

 

Thank You!

Matt


SAS_EG_Query.PNG
Super User
Posts: 19,093

Re: While writing a permanent dataset to Impala

Is there something in the code that is hanging?

Missing semicolon, missing quit or a sleep? 

Occasional Contributor
Posts: 19

Re: While writing a permanent dataset to Impala

Reeza,

 

No, everything seems to be correct. What I learned is that I am writing a permenent SAS dataset to Impala without a BULKLOAD option and it is taking time to complete the process but for whatever reason the EG tasks window continues to display the message "Job is running" something like that.. sometime it comes back normal and display the log and dataset I created and sometime it doesn't. We have SAS EG 6.1, upgrading to next version might help. 

 

Let me know if you have any other solutions or options that would help me deal with this issue. 

 

Thanks!

Matt

Super User
Posts: 19,093

Re: While writing a permanent dataset to Impala

I don't have anything else Smiley Sad

 

If you haven't contacted SAS Support, I would highly suggest you do so. They're usually pretty helpful and quick.

Occasional Contributor
Posts: 19

Re: While writing a permanent dataset to Impala

No worries Reeza. I already had a discussion with SAS TS since the error is not consistent they recommend to upgrade EG versions and we will be upgrading maintenance version to next available version in few months, let's hope that solve the issue. Also working on to fix the issues with BULKLOAD since it only works with SERVER= option and not with DSN= option. It's a defect and SAS is going to address it in next release or a hotfix. 

 

Thank You!

Matt

Ask a Question
Discussion stats
  • 4 replies
  • 195 views
  • 1 like
  • 2 in conversation