Examples: query, "exact match", wildcard*, wild?ard, wild*rd
Fuzzy search: cake~ (finds cakes, bake)
Term boost: "red velvet"^4, chocolate^2
Field grouping: tags:(+work -"fun-stuff")
Escaping: Escape characters +-&|!(){}[]^"~*?:\ with \, e.g. \+
Range search: properties.timestamp:[1587729413488 TO *] (inclusive), properties.title:{A TO Z}(excluding A and Z)
Combinations: chocolate AND vanilla, chocolate OR vanilla, (chocolate OR vanilla) NOT "vanilla pudding"
Field search: properties.title:"The Title" AND text
Answered
Hi Everyone, I'M Encountering This Sqlalchemy Error While Running The Pipeline Using Asteroid Dataset "Sqlalchemy.Exc.Objectnotexecutableerror: Not An Executable Object: 'Select * From Asteroids Where Strftime("%Y-%M-%D", `Date`) <= Strftime("%Y-%M-%D",

Hi Everyone, I'm encountering this SQLAlchemy error while running the pipeline using Asteroid Dataset

"sqlalchemy.exc.ObjectNotExecutableError: Not an executable object: 'SELECT * FROM asteroids WHERE strftime("%Y-%m-%d", date) <= strftime("%Y-%m-%d", "2022-01-01")'

Is anyone aware how to resolve this?

  
  
Posted one year ago
Votes Newest

Answers


Hi @<1529633462108033024:profile|SucculentCrab55> ! In which step do you get this error? I assume get_data? Does it work locally?

  
  
Posted one year ago
954 Views
1 Answer
one year ago
one year ago
Tags