ROXIE FAQs
- How I can compile a query on a containerized or cloud-based system?
Answer:
Same way as bare metal. Command line, or with the IDE, or from ECL Watch. Just point to the HPCC Systems instance to compile.
For Example:
ecl deploy <target> <file>- How do I copy queries from an on-prem cluster to Azure?
Answer:
The copy query command – use the Azure host name or IP address for the target.
For example:
ecl queries copy <source_query_path> <target_queryset>- How can I get the IP address for the Azure target cluster?
Answer:
Use the "kubectl get svc" command. Use the external IP address listed for ECL Watch.
kubectl get svc- Do we have to have use the DNSName or do we need to use the IP address?
Answer:
If you can reach ECL Watch with the DNS Name then it should also work for the command line.- How can I find the ECL Watch or Dali hostname?
Answer:
If you did not set up the containerized instance, then you need to ask your Systems Administrator or whomever set it up..- How do I publish a package file?
Answer:
Same way as bare metal.
To add a new package file, specify the Roxie target and package file:
ecl packagemap add <target> <filename> --activate
To copy an existing package file, specify the source path and Roxie target:
ecl packagemap copy <source-path> <target>
The <target> argument is required and must identify the Roxie target.- How do I check the logs?
Answer:
kubectl log <podname>
in addition you can use -f (follow) option to tail the logs. Optionally you can also issue the <namespace> parameter.
For example:
kbectl log roxie-agent-1-3b12a587b –namespace MyNameSpace
Optionally, you may have implemented a log-processing solution such as the Elastic Stack (elastic4hpcclogs).- How do I get the data on to Azure?
Answer:
Use the copy query command and copy or add the Packagemap, specifying the
required Roxie target with the package-map command.
With data copy start in the logs…copy from remote location specified if data doesn’t exist on the local system.
The remote location is the remote Dali (use the --daliip=<daliIP> parameter to specify the remote Dali)
You can also use ECL Watch.
You can also use the kubectl cp command to copy data files directly into a pod's drop zone. For example:
kubectl cp mydata.csv <pod-name>:/var/lib/HPCCSystems/mydropzone/mydata.csv
See the "Copying Files To and From a Pod" section in the Containerized HPCC Systems Platform book for more details.- How can I start a cloud cluster? (akin to the old Virtual Box image)?
Answer:
Can use Docker Desktop, or Azure or any cloud provider and install the HPCC Systems Cloud native helm
charts- How can I show the ECL queries that are published to a given Roxie?
Answer:
Can use WUListQueries
For example:
https://[eclwatch]:18010/WsWorkunits/WUListQueries.json?ver_=1.86&ClusterName=roxie&CheckAllNodes=0- I set up persistent storage on my containerized HPCC Systems, and now it won't start. Why?
Answer:
One possible reason may be that all of the required storage directories are not present. The directories for ~/
hpccdata/dalistorage, hpcc-data, debug, queries, sasha, and dropzone are all required to exist or your cluster may not start.- Are there any new methods available to work with queries?
Answer:
Yes. There is a new method available ServiceQuery.
https://[eclwatch]:18010/WsResources/ServiceQuery?ver_=1.01&
For example Roxie Queries:
https://[eclwatch]:18010/WsResources/ServiceQuery?ver_=1.01&Type=roxie
or WsECL (eclqueries)
https://[eclwatch]:18010/WsResources/ServiceQuery?ver_=1.01&Type=eclqueries