Feras Saad

CGPM_Metamodel should casefold categorical conditions

1

Consider using lower case `meo`, which is being converted to `null` and hence probability 1: ```python bdb = bayeslite.bayesdb_open('satellites.2048.bdb') query(bdb, ''' ESTIMATE PROBABILITY OF class_of_orbit = 'meo' GIVEN (period_minutes=850) WITHIN...

bdb.execute(sql) fails but bdb.sql_execute(sql) succeeds on SELECT

4

``` bdb = bayeslite.bayesdb_open('resources/gapminder.bdb') pairwise = query(bdb, 'SELECT name0, name1 FROM dependence;') for row in pairwise.values[:1]: name0, name1 = row sql = ''' SELECT %s, %s FROM %s ''' %...

Implement INSERT INTO for metamodel (i.e. incorporating rows)

1

On June 28, a partial implementation of `INSERT INTO` was (rightfully) nixed: 5bf3d2d1ec3f71518f8ad27e6100feb3419c73e5 The architecture now with population `p` and table `t` suggests the following workflow. ```sql CREATE TABLE t...

SIMULATE with a latent variable fails when inside a CREATE TABLE clause

1

``` %%bql SIMULATE name, flower_pc1, flower_pc2 FROM iris_p MODELED BY iris_g LIMIT 10; ``` works fine, but ``` %%bql CREATE TABLE flower_pc_components4 AS SIMULATE name, flower_pc1, flower_pc2 FROM iris_p MODELED...

# Using A Causal Probabilistic Program & Non-Parametric Bayes To Model Kepler's Law In this notebook, we are going to write a custom probabilistic program in VentureScript to implement at...

If `CGPM_Metamodel.multiprocess` is `True`, we should replace the following serial map to use `parallel_map`: https://github.com/probcomp/bayeslite/blob/master/src/metamodels/cgpm_metamodel.py#L200-L201 ```python cgpms = [self._initialize_cgpm(bdb, generator_id, cgpm_ext) for _ in xrange(n)] ```

Consider ``` CREATE POPULATION p FOR t( a NUMERICAL, b NUMERICAL, ); CREATE GENERATOR g0 FOR p USING cgpm( ); CREATE GENERATOR g1 FOR p USING cgpm( a LOGNORMAL LATENT...

Implement BQL syntax for multiple/joint imputation

1

Currently ``` INFER EXPLICIT PREDICT x, PREDICT y FROM p ``` imputes `x` and `y` from their marginals. We need BQL syntax for imputing from the joint distribution ``` INFER...

New lines with dot command not possible

1

If I write .show followed by incomplete query, the terminal takes the current input rather than prompt for new lines. ``` sql bayeslite> .show 'SELECT * FROM Traceback (most recent...

This issue relates to cgpm_metamodel (and more generally, any metamodel supporting categorical variables). Suppose I have a CGPM `x` which outputs integer `0` for `False` and integer `1` for `True`....