Course Hero Logo

Non numeric values must be enclosed in double quotes

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 59 - 62 out of 72 pages.

Non-numeric values must be enclosed in "double quotes"22.Are field values treated in a case sensitive manner when using the iffunction with the eval command?Yes they are case sensitive23.How would you use the case function with the eval command?case(X1, Y1, X2, Y2...)- the 1st argument, X1, is a Boolean expression- if it evaluates to TRUE, the result evaluates to Y1- if it evaluates to FALSE, the next Boolean expression, X2, isevaluated, etc.- if you want an "otherwise: clause, just test for a conditionyou know is true at the end(e.g., 0=0)24.Explain when and how to use the eval function?You would use the eval function to count the number ofevents that contain a specific field value, use the count andeval functions25.When using a transforming command like stats what is required?
- An as clause is required- Double quotes are required for character field values- Field values are case sensitive26.What are some of the attributes of the search command?- Treats field values in a case insensitive manner- Allows searching on keyword- Can be used at any point in the search pipeline27.What are some of the attributes of the where command?- Can compare values from two different fields- Functions are available, such as isnotnull()- Treats field values in a case sensitive manner- Can not appear before the first pipe in search pipeline28.How does the search command behave when used?It behaves exactly like search strings before the first pipe andit can also use the "*" wildcard29.How does the where command behave when used?- Uses same expression syntax as the eval command- Uses boolean expressions to filter search results and onlykeeps resultsthat are True- Double quoted strings are interpreted as field values (treatsfieldvalues in a case sensitive manner)- Unquoted or single-quoted strings are treated as fields30.True or False: The where command is also used to compare twodifferent fields?True31.True or False: Can you do wildcard searches with the where command?True32.In what situation would you use (_) and (%) when using the wherecommand?You would use the "_" for one character and "%" for multiplecharacters33.What must you use with wildcards when using the where command?You must use the "like" operator34.When would you use the fillnull command?You would use the fillnull command to replace null values infields35.How would you specify a string you wanted to display when using thefillnull command?You use the value=stringexample: fillnull value=NULL36.What happens if you don't have a value= clause when using thefillnull command?The default replacement value is 037.How would you restrict which fields fillnull command would apply?By listing them at the end of the commandexample: fillnull VALUE="N/A" discount refund
Correlating Events Mod 6 Flashcards Preview1.What is a Transaction?

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 72 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
Donghui Yan
Tags

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture